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

From Per-Olov Esgard
Subject Re: Is there any problem with pg_notify and memory consumption?
Date
Msg-id OF721A3E89.611A1F43-ONC12578A0.002022BC-C12578A0.00204671@micronic-mydata.com
Whole thread Raw
In response to Re: Is there any problem with pg_notify and memory consumption?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
The patch seemed to work for me too.

Thanks.

Regards,   Per-Olov Esgård




From:        Tom Lane <tgl@sss.pgh.pa.us>
To:        Per-Olov Esgard <Per-Olov.Esgard@micronic-mydata.com>
Cc:        Merlin Moncure <mmoncure@gmail.com>, pgsql-general@postgresql.org
Date:        05/27/2011 06:19 PM
Subject:        Re: [GENERAL] Is there any problem with pg_notify and memory consumption?




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



The information contained in this communication and any attachments may be confidential and privileged, and is for the sole use of the intended recipient(s). If you are not the intended recipient, you are hereby formally notified that any unauthorized review, use, disclosure or distribution of this message is prohibited. Please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. Micronic Mydata is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt.

pgsql-general by date:

Previous
From: Leif Jensen
Date:
Subject: Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs
Next
From: "Carlos Sotto Maior \(SIM\)"
Date:
Subject: RES: SELECT COUNT(*) execution time on large tables (v9.0.4-1)