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 sequences in postgresql?
How to write pl sql in postgresql?
What is multi-version control?
How to connect to postgres database using pgadmin?
Explain about concurreny with the help of MVCC?
What is the default password for postgres windows?
What is toast in postgres?
How does clustering in improving the performance?
Is index automatically created on primary key?
Is postgresql good?
What is primary key in postgresql?
How to create a postgresql database?
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)