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 |
What is dummy table?
What is a primary key constraint?
What is the difference between sql and psql?
What is catalog in postgresql?
How the stats updated in postgresql?
How to find table creation date in postgresql?
How do I stop postgresql server?
How do I add a foreign key in pgadmin?
What is foreign key violation?
Are foreign key constraints necessary?
How do I stop a postgresql console?
Where is pg_hba conf file?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)