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

Поиск
Список
Период
Сортировка
От Per-Olov Esgard
Тема Re: Is there any problem with pg_notify and memory consumption?
Дата
Msg-id OF721A3E89.611A1F43-ONC12578A0.002022BC-C12578A0.00204671@micronic-mydata.com
обсуждение исходный текст
Ответ на Re: Is there any problem with pg_notify and memory consumption?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Leif Jensen
Дата:
Сообщение: Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs
Следующее
От: "Carlos Sotto Maior \(SIM\)"
Дата:
Сообщение: RES: SELECT COUNT(*) execution time on large tables (v9.0.4-1)