Re: [HACKERS] optimization histograms

[Kevin Grittner]

amit sehas  wrote:
 
> for the histograms for cost based optimization, is there a rule of
> thumb on how often to rebuild them?
 
In recent major versions, autovacuum should normally keep you in
good shape.  The exception is when you make major changes to the
contents of a table (such as in a bulk data load) and then
immediately try to use the table before autovacuum has had time to
notice the activity and generate fresh statistics; for these cases
you probably want to do a manual run.
 
For more information, see:
 
http://www.postgresql.org/docs/current/interactive/routine-vacuuming.html#VACUUM-FOR-STATISTICS
 
-Kevin

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] optimization histograms

[amit sehas]

HI,

for the histograms for cost based optimization, is there a rule of thumb on how 
often to rebuild them? They are obviously not being continuously updated...what 
is the state of the art in this area, do all the other databases also end up 
with stale statistics every now and then and have to keep rebuilding the stats?

thanks
-Amit


  

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers