Vacuum with the option Analyze is used to update statistics in Postgresql

How is the statistics in PostgreSQL updated?

Question Posted / madhub

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

Please Help Members By Posting Answers For Below Questions

How do I connect to postgresql on windows?

836

What are the rules of setting a primary key?

768

What is pg server?

831

How do you insert rows and columns?

735

Does google use postgresql?

824

Is mysql a postgresql?

782

What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

1209

Does postgres use sql?

782

What does the option psql -l of PostgreSQL display?

1372

What is the point of foreign keys?

721

What is the difference between postgresql and sql?

757

What is sequelize?

733

What is unlogged table?

737

Explain multi version concurrency control.

865

Why Update is too slow

1344