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 sql a postgresql?
Do indexes speed up queries?
How do I add a foreign key in pgadmin?
How many rows can postgresql handle?
What is postmaster in postgresql?
What is character varying in postgres?
What is the point of foreign keys?
Does postgres support json?
What does postgresql stand for?
What is postgresql jdbc driver?
Does postgres create indexes for foreign keys?
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)