optimization histograms

From: amit sehas <cun23(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: optimization histograms
Date: 2010-12-21 16:51:12
Message-ID: 512191.93810.qm@web32201.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2010-12-21 17:32:03 Re: optimization histograms
Previous Message tv 2010-12-21 16:30:17 Re: proposal : cross-column stats