Re: fixing LISTEN/NOTIFY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: fixing LISTEN/NOTIFY
Date
Msg-id 16499.1128604378@sss.pgh.pa.us
Whole thread Raw
In response to Re: fixing LISTEN/NOTIFY  (Neil Conway <neilc@samurai.com>)
Responses Re: fixing LISTEN/NOTIFY
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> However, I don't really like the idea of blocking the backend for a
> potentially significant amount of time in a state half-way between
> "committed" and "ready for the next query".

I wonder whether we could use something comparable to pg_multixact
or pg_subtrans, to convert the problem from one of "need to fit in
fixed amount of memory" to one of "it's on disk with some buffers
in memory".
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: version dependent compilation
Next
From: Tom Lane
Date:
Subject: Re: Outer where pushed down