Re: Is there any problem with pg_notify and memory consumption?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Per-Olov Esgard <Per-Olov(dot)Esgard(at)micronic-mydata(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is there any problem with pg_notify and memory consumption?
Date: 2011-05-27 16:19:14
Message-ID: 15217.1306513154@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I wrote:
> I think the right fix is to make sure that ProcessCompletedNotifies
> saves and restores the call-time CurrentMemoryContext.

The patch committed here appears to fix it for me:
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=722548e4309c28631ada292fe6cad04ae8f9c151

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Sotto Maior (SIM) 2011-05-27 16:41:36 SELECT COUNT(*) execution time on large tables (v9.0.4-1)
Previous Message Merlin Moncure 2011-05-27 16:15:25 Re: Is there any problem with pg_notify and memory consumption?