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
- pgsyslogger2.patch (text/x-patch) patch
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