Re: CLOG contention
Merlin Moncure <mmoncure@gmail.com>
From: Merlin Moncure <mmoncure@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2012-01-05T19:34:55Z
Lists: pgsql-hackers
On Thu, Jan 5, 2012 at 1:12 PM, Robert Haas <robertmhaas@gmail.com> wrote: > On Thu, Jan 5, 2012 at 11:10 AM, Simon Riggs <simon@2ndquadrant.com> wrote: >> Let's commit the change to 32. > > I would like to do that, but I think we need to at least figure out a > way to provide an escape hatch for people without much shared memory. > We could do that, perhaps, by using a formula like this: > > 1 CLOG buffer per 128MB of shared_buffers, with a minimum of 8 and a > maximum of 32 The assumption that machines that need this will have gigabytes of shared memory set is not valid IMO. merlin