Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor performance on SCSI machines, good on IDE? - Mailing list pgsql-general

From Tom Lane
Subject Re: Poor performance on SCSI machines, good on IDE?
Date
Msg-id 26240.1005926776@sss.pgh.pa.us
Whole thread Raw
In response to Poor performance on SCSI machines, good on IDE?  (Eric Crampton <eric@atdesk.com>)
List pgsql-general
Tree view 
Eric Crampton <eric@atdesk.com> writes:
> Incidently, if I turn fsync off on the SCSI machines, the performance
> absolutely soars. Of course, I don't really want to do this in
> production.

Have you tried experimenting with the WAL_SYNC_METHOD parameter?
On some kernels that can make a big difference.  Not sure why
the apparent correlation to disk drive type, though.

            regards, tom lane

pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Re: Idle in transaction ????
Next
From: Gabriel Fernandez
Date:
Subject: Re: Precision problems with float8