Skip site navigation (1) Skip section navigation (2)

Re: Reducing Transaction Start/End Contention

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Reducing Transaction Start/End Contention
Date: 2007-07-31 16:05:59
Message-ID: 25697.1185897959@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Simon Riggs wrote:
>> 1. Increase size of Clog-specific BLCKSZ

>> 2. Perform ExtendClog() as a background activity

>> (1) and (2) can be patched fairly easily for 8.3. I have a prototype
>> patch for (1) on the shelf already from 6 months ago.

> Hmm, I think (1) may be 8.3 material but all the rest are complex enough
> that being left for 8.4 is called for.

NONE of this is 8.3 material.  Full stop.  Try to keep your eyes on the
ball people --- 8.3 is already months past feature freeze.

I don't even think that Simon has made a case that #1 is a good idea.
Increasing the page size will increase contention between transactions
trying to hit the same clog page, no?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2007-07-31 16:12:52
Subject: Re: Machine available for community use
Previous:From: Greg SmithDate: 2007-07-31 15:55:00
Subject: Re: Machine available for community use

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group