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
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 k