How is the statistics in PostgreSQL updated?
- 1 Answers
- 2549 Views
- I also Faced
- E-Mail Answers
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 |
More Postgre Interview Questions
What is the use of vacuum in postgresql?
How to drop all tables in postgresql?
How do I modify a table in postgresql?
Explain about Write Ahead logging?
Is mysql faster than postgresql?
What will be the new characteristics of postgre 9.1?
What is maximum size of text datatype in postgres?
How to change postgresql root user password?
How do I create a database in pgadmin 4?
How do you delete a row in pgadmin 4?
What is foreign key in postgresql?
Does aws support postgresql?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
