Re: Postgresql 9.2 OOM

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bryanck <bryanck(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 9.2 OOM
Date: 2012-09-30 05:51:35
Message-ID: 16449.1348984295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

bryanck <bryanck(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Waldo, Ethan 2012-09-30 06:36:57 transitive pruning optimization on the right side of a join for partition tables
Previous Message bryanck 2012-09-30 05:28:39 Re: Postgresql 9.2 OOM