Re: Further reduction of bufmgr lock contention

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Hamill <gdh(at)acentral(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Further reduction of bufmgr lock contention
Date: 2006-05-23 16:05:34
Message-ID: 14969.1148400334@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gavin Hamill <gdh(at)acentral(dot)co(dot)uk> writes:
> It's been about a month since the last activity on bufmgr as documented
> on the hackers list and I was just concerned that this issue had been
> filed as an interesting toy at the time, but now left for the circular
> filing cabinet :)

> Tom + Simon were able to see a fairly easy 25% performance boost against
> our dataset and I'd obv. be very keen to see this work make it into
> 8.1.4 or 8.2.0 :)

We're certainly not putting any such thing into 8.1.*. The proposed
patch for 8.2 is stalled ATM because of the problem of not having a
predictable size for the per-partition hash tables. Fixed-size shared
memory is a harsh mistress :-(

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Joseph Krogh 2006-05-23 16:10:27 Re: file-locking and postmaster.pid
Previous Message Tom Lane 2006-05-23 15:54:37 Re: file-locking and postmaster.pid