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 do you mean by catalog?

632


Does drop table also drop indexes?

604


What is the driver name for postgresql?

606


How do I connect to a postgresql database remotely?

596


What is the default postgres database?

592


What is shared_buffers postgresql?

631


Why is pgadmin used?

637


What is a user view?

582


How to get the ddl of a table in postgresql?

634


Is mysql better than postgresql?

655


What does edb stand for?

802


What is a postgresql schema?

598


Where is postgresql conf?

660


How to write sql script in postgresql?

609


What is postgres xc?

601