Re: pg_listener entries deleted under heavy NOTIFY load only on Windows

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Radu Ilie <rilie(at)wsi(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_listener entries deleted under heavy NOTIFY load only on Windows
Date: 2010-01-25 12:37:18
Message-ID: 4B5D907E.8020603@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Craig Ringer wrote:
> On 23/01/2010 5:30 AM, Radu Ilie wrote:
>> On a Windows server under heavy load of NOTIFY events, entries in
>> pg_listener table for some events are deleted. It is like UNLISTEN was
>> called.
>
> This has been reported on -general, then -bugs, now -hackers, and seems
> to just get ignored. The poster has done a fair bit of research and has
> documented the issue, and fix, in a fair bit of depth.
>
> I don't have the access rights to do anything about it. Is someone who
> does going to look at it, or will it remain a lurking bug?
>
> (If this has since made it into cvs without any ML activity, then sorry
> - but I'm worried it'll get missed again and want to make sure it doesn't.)

well it is on the Open Items list for a while now:

http://wiki.postgresql.org/wiki/PostgreSQL_8.5_Open_Items so I won't be
forgotten...

Stefan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2010-01-25 13:01:35 Re: Questions about connection clean-up and "invalid page header"
Previous Message Pavel Stehule 2010-01-25 12:36:49 Re: quoting psql varible as identifier