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

Why foreign key constraint is important?

589


How do I start postgresql?

619


Where is postgresql conf in mac?

700


What is difference between postgresql and mysql?

640


How to select distinct on multiple columns?

625


What is the use of vacuum in postgresql?

606


How do I set up postgresql?

623


Is index automatically created on primary key?

615


Is it postgre or postgres?

600


Is postgresql secure?

635


How do I add another column in postgresql?

605


Is postgresql is nosql?

598


What happens to index when table is dropped?

617


What is pg_catalog in postgres?

601


Is postgresql cloud based?

586