Re: Proposal of tunable fix for scalability of 8.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Proposal of tunable fix for scalability of 8.4
Date
Msg-id 14217.1237564545@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal of tunable fix for scalability of 8.4  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
Matthew Wakeling <matthew@flymine.org> writes:
> As for ProcArrayLock, it sounds like it is very much a special case.

Quite.  Read the section "Interlocking Transaction Begin, Transaction
End, and Snapshots" in src/backend/access/transam/README before
proposing any changes in this area --- it's a lot more delicate than
one might think.  We'd have partitioned the ProcArray long ago if
it wouldn't have broken the transaction system.

            regards, tom lane

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
Next
From: Jeff
Date:
Subject: Re: current transaction in productive database