How is the statistics in PostgreSQL updated?
Answer / madhub
Vacuum with the option Analyze is used to update statistics in Postgresql
VACUUM ANALYZE ; is the syntax.
Is This Answer Correct ? | 0 Yes | 0 No |
Do foreign keys speed up queries?
Explain multi version concurrency control.
What is composite foreign key?
How do I change the order of columns in postgresql?
What is postmaster in postgresql?
What happens to index when table is dropped?
What is sequence in postgresql?
Can a unique key be a foreign key?
How to open postgresql gui in ubuntu?
What is gis data?
Where is pg_hba conf file?
What are the types of stored procedures?