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 do we need connection pooling?

430


What is instance in postgresql?

450


How will you add a new style in a table?

447


How to check dependency of table in postgresql?

479


How do I start pgadmin 4 on windows?

444






Is postgresql distributed?

427


Is postgresql similar to sql server?

440


Is postgresql secure?

452


What is pg pool?

446


Is mysql better than postgresql?

476


What type of database is postgres?

440


How is data stored in postgresql?

467


What is pgrouting?

445


What is the default postgres database?

409


How do I connect to an rds postgres database?

457