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 |
Is postgresql better than oracle?
What is a postgresql schema?
What is postgresql? Explain the history of postgresql.
What are the common bugs found while migrating to MySQL db to Postgre?
Where is postgresql conf in mac?
What is the default postgres user?
What is the difference between oracle and postgresql?
Is foreign key should be unique?
Is postgres a database?
How do I open a pgadmin file in windows?
What type of database is postgresql?
What is connection limit in postgresql?
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)