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

How do you change the name of a column?

439


What is shared_buffers postgresql?

438


What is the password of postgres user?

502


Which is faster mysql or postgresql?

471


What is ora2pg?

416






Does aws support postgresql?

528


Is it postgre or postgres?

455


How to set up local postgres database?

426


Is postgresql cloud based?

397


How to open postgresql gui in ubuntu?

431


What is pg_toast?

417


Does postgres have clustered index?

434


How do I start postgresql in linux?

440


How do I add a primary key in pgadmin?

438


How do you create a table in pgadmin?

446