Re: Poor performance on SCSI machines, good on IDE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Crampton <eric(at)atdesk(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Poor performance on SCSI machines, good on IDE?
Date: 2001-11-16 16:06:16
Message-ID: 26240.1005926776@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Eric Crampton <eric(at)atdesk(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message K. Ari Krupnikov 2001-11-16 16:08:04 table names
Previous Message wsheldah 2001-11-16 15:26:24 Re: Idle in transaction ????