Re: Maximum transaction rate - Mailing list pgsql-general

From Greg Smith
Subject Re: Maximum transaction rate
Date
Msg-id alpine.GSO.2.01.0903061328280.7392@westnet.com
Whole thread Raw
In response to Re: Maximum transaction rate  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Maximum transaction rate
List pgsql-general
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

hdparm -I lets you check if write caching is on, hdparm -W lets you toggle
it off.  That's for ATA disks; SCSI ones can use sdparm instead, but
usually it's something you can adjust more permanently in the card
configuration or BIOS instead for those.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

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