postgres SQL - pg_class question
Posted
by Sachin Chourasiya
on Stack Overflow
See other posts from Stack Overflow
or by Sachin Chourasiya
Published on 2010-04-17T11:51:44Z
Indexed on
2010/04/17
12:03 UTC
Read the original article
Hit count: 261
postgressql
|pg-class
PostgreSQL stores statistics about tables in the system table called pg_class. The query planner accesses this table for every query. These statistics may only be updated using the analyze command. If the analyze command is not run often, the statistics in this table may not be accurate and the query planner may make poor decisions which can degrade system performance. Another strategy is for the query planner to generate these statistics for each query (including selects, inserts, updates, and deletes). This approach would allow the query planner to have the most up-to-date statistics possible.
Why postgres always rely on pg_class instead?
© Stack Overflow or respective owner