On Wed, Apr 9, 2008 at 1:41 PM, David Wilson <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general