This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold
--------------------------------------------------------------------------- Greg Smith wrote: > On Thu, 2 Aug 2007, Tom Lane wrote: > > > I find it entirely likely that simply changing the [NUM_CLOG_BUFFERS] > > constant would be a net loss on many workloads. > > Would it be reasonable to consider changing it to a compile-time option > before the 8.3 beta? From how you describe the potential downsides, it > sounds to me like something that specific distributors might want to > adjust based on their target customer workloads and server scale. That > would make it available as a tunable to those aiming at larger systems > with enough CPU/memory throughput that the additional overhead of more > linear searches is trumped by the reduced potential for locking > contention, as appears to be the case in Sun's situation here. > > -- > * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org