optimization histograms - Mailing list pgsql-hackers

From amit sehas
Subject optimization histograms
Date
Msg-id 512191.93810.qm@web32201.mail.mud.yahoo.com
Whole thread Raw
Responses Re: optimization histograms  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
HI,

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

thanks
-Amit

     


pgsql-hackers by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: proposal : cross-column stats
Next
From: "Kevin Grittner"
Date:
Subject: Re: optimization histograms