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

What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?

1084

How do I add a foreign key in pgadmin?

461

Is postgres a database?

426

How do you check data on pgadmin 4?

428

What is multi-version control?

419

Can a unique key be a foreign key?

439

What language is postgresql written in?

427

What is postgres vacuum?

439

What port does postgresql use?

421

What port does postgresql listen on?

425

How do I change primary key in pgadmin?

445

What is postgresql dba?

452

How do I rename a column in postgresql?

446

How do I connect to postgresql access?

409

Is postgresql free for commercial use?

448