Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there any problem with pg_notify and memory consumption? - Mailing list pgsql-general

From Tom Lane
Subject Re: Is there any problem with pg_notify and memory consumption?
Date
Msg-id 15217.1306513154@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is there any problem with pg_notify and memory consumption?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Is there any problem with pg_notify and memory consumption?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Is there any problem with pg_notify and memory consumption?
Next
From: "Carlos Sotto Maior \(SIM\)"
Date:
Subject: SELECT COUNT(*) execution time on large tables (v9.0.4-1)