[HACKERS] optimization histograms

2010-12-21 Thread 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

Re: [HACKERS] optimization histograms

2010-12-21 Thread Kevin Grittner
amit sehas cu...@yahoo.com 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