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 performance_schema?
How to set up local postgres database?
Where is pg_hba conf?
What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?
What is vacuuming in postgresql?
How do I create a database in pgadmin 4?
What is postgres default password?
What does postgresql mean?
What is the difference between postgresql and sql?
How do I change the default port for postgresql?
How do you create a foreign key in pgadmin 4?
What is pg_toast?
Oracle (3253)
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)