How is the statistics in PostgreSQL updated?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between postgresql and mysql?

610


How do I change the order of columns in postgresql?

571


PostgreSql Disadvantages

1614


Does postgresql have a gui?

502


What is connection limit in postgresql?

566






Where is pg_hba conf file?

551


Is index automatically created on primary key?

592


What is pg_hba conf file?

585


How to find table creation date in postgresql?

578


How to drop all tables in postgresql?

588


How do I stop postgresql server?

589


What language is postgresql written in?

592


What is bytea in postgres?

595


What is varchar in postgresql?

542


What is the driver name for postgresql?

563