Re: log chunking broken with large queries under load

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-04-03T21:09:56Z
Lists: pgsql-hackers

Attachments


On 04/02/2012 01:03 PM, Tom Lane wrote:
> Andrew Dunstan<andrew@dunslane.net>  writes:
>> On 04/02/2012 12:44 PM, Tom Lane wrote:
>>> You could do something like having a list of pending chunks for each
>>> value of (pid mod 256).  The length of each such list ought to be plenty
>>> short under ordinary circumstances.
>> Yeah, ok, that should work. How big would we make each list to start
>> with? Still 20, or smaller?
> When I said "list", I meant a "List *".  No fixed size.
>
> 			

Ok, like this? Do we consider this a bug fix, to be backpatched?

cheers

andrew