How is the statistics in PostgreSQL updated?

Question Posted / madhub

How is the statistics in PostgreSQL updated?..

Answer / 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

More Postgre Interview Questions

What is the driver name for postgresql?

How to create a postgresql database?

What is bigint in postgresql?

What is a foreign key constraint why are such constraints important?

How do I change primary key in pgadmin?

Does postgres create indexes for foreign keys?

What are the various enhancements to the straight relational data model by PostgreSQL?

How do I change the datatype in postgresql?

What is meant by postgresql?

What is serial data type in postgresql?

How to write sql script in postgresql?

What is postgis and postgresql?

For more Postgre Interview Questions Click Here