On Wed, Apr 9, 2008 at 1:41 PM, David Wilson <david.t.wilson@xxxxxxxxx> wrote: > > > I've run into a very similar problem. I have some long-running > processes that generate a large amount of data and then query that > data that must periodically drop their connections and rebuild to > ensure that query plans get re-planned according to updated > statistics. This is especially true when a new DB is first being > brought up with an initial set of data (~1 week of compute time, ~30gb > of data and ~120m rows) with processes that live through the entire > process. > I believe plan-invalidation in 8.3 should address this. Isn't it ? Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com
