Re: Maximum transaction rate - Mailing list pgsql-general

From Ben Chobot
Subject Re: Maximum transaction rate
Date
Msg-id Pine.LNX.4.64.0903061320270.10022@localhost.localdomain
Whole thread Raw
In response to Re: Maximum transaction rate  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: Maximum transaction rate
Re: Maximum transaction rate
List pgsql-general
On Fri, 6 Mar 2009, Greg Smith wrote:

> On Fri, 6 Mar 2009, Tom Lane wrote:
>
>>  Otherwise you need to reconfigure your drive to not cache writes.
>>  I forget the incantation for that but it's in the PG list archives.
>
> There's a dicussion of this in the docs now,
> http://www.postgresql.org/docs/8.3/interactive/wal-reliability.html

How does turning off write caching on the disk stop the problem with LVM?
It still seems like you have to get the data out of the OS buffer, and if
fsync() doesn't do that for you....

pgsql-general by date:

Previous
From: "Eric B. Ridge"
Date:
Subject: Re: set-valued function called in context that cannot accept a set
Next
From: Scott Marlowe
Date:
Subject: Re: Maximum transaction rate