Re: Postgresql 9.2 OOM - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql 9.2 OOM
Date
Msg-id 16449.1348984295@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql 9.2 OOM  (bryanck <bryanck@gmail.com>)
Responses Re: Postgresql 9.2 OOM
List pgsql-general
bryanck <bryanck@gmail.com> writes:
> One further question, how exactly can a CachedPlan leak? The OpenStreetMap
> data load does use plsql and triggers are involved as well. Is there
> something new to 9.2 that changes the way CachedPlans are cleaned up?

9.2 is more aggressive about caching plans, but you've provided no
details that would allow somebody else to investigate this report.

            regards, tom lane


pgsql-general by date:

Previous
From: bryanck
Date:
Subject: Re: Postgresql 9.2 OOM
Next
From: "Waldo, Ethan"
Date:
Subject: transitive pruning optimization on the right side of a join for partition tables