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 edb postgres?
How do I connect to postgresql database from windows?
Does aws support postgresql?
How do I set up postgresql?
How do I connect to pgadmin server?
How do I connect to postgresql server?
Why are stored procedures used?
Where is psql data stored?
What is the port 5432?
What is an ssh tunnel?
How many rows can postgresql handle?
What is regclass 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)