Re: shared_buffers advice - Mailing list pgsql-performance

From Tom Lane
Subject Re: shared_buffers advice
Date
Msg-id 15895.1268778326@sss.pgh.pa.us
Whole thread Raw
In response to Re: shared_buffers advice  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: shared_buffers advice
List pgsql-performance
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane escribió:
>> That's not going to do anything towards reducing the actual I/O volume.
>> Although I suppose it might be useful if it just cuts the number of
>> seeks.

> Oh, they had no problems with I/O volume.  It was relation extension
> lock that was heavily contended for them.

Really?  I guess that serialized all the I/O ... I'll bet if we got rid
of that locking somehow, they *would* have a problem with I/O volume.

            regards, tom lane

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: shared_buffers advice
Next
From: Alvaro Herrera
Date:
Subject: Re: shared_buffers advice