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 postmaster in postgresql?
Is postgresql a virus?
What is difference between drop and delete?
How do I delete a query?
How do I create a database in pgadmin 4?
i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha
How to setup postgresql sysv startup script?
What is toast in postgres?
What is the blob data type?
What is mvcc in postgresql?
How do I add one column in postgresql?
Where is postgres configuration file?
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)