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 |
Where is postgres configuration file?
How do you delete data on pgadmin?
What are the types of stored procedures?
Who invented postgresql?
What are the common bugs found while migrating to MySQL db to Postgre?
What is aws aurora postgres?
What is wal in postgresql?
Put some light on multi-version concurrency control?
What is the password of postgres user?
How do you change the name of a column?
Why is pgadmin used?
What is postgresql client?
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)