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 the difference between a primary key and a composite key?
How do you change constraints in postgresql?
How do I get a list of databases in a postgresql database?
What is primary key in postgresql?
What is the command that can be used to allocate memory in postgreSQL?
What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes
What is postgresql database cluster?
What is blob in postgresql?
How do I connect to pgadmin?
How to start the database server?
What do you mean by catalog?
How many indexes per table are allowed 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)