Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor performance on seq scan - Mailing list pgsql-performance

From Laszlo Nagy
Subject Re: Poor performance on seq scan
Date
Msg-id 45072B61.3080506@designaproduct.biz
Whole thread Raw
In response to Re: Poor performance on seq scan  ("Craig A. James" <cjames@modgraph-usa.com>)
Responses Re: Poor performance on seq scan
Re: Poor performance on seq scan
List pgsql-performance
Tree view 
Craig A. James wrote:
>
> There IS a bug for SATA disk drives in some versions of the Linux
> kernel.  On a lark I ran some of the I/O tests in this thread, and
> much to my surprise discovered my write speed was 6 MB/sec ... ouch!
> On an identical machine, different kernel, the write speed was 54 MB/sec.
My disks are running in SATA150 mode. Whatever it means.

I'm using FreeBSD, and not just because it dynamically alters the
priority of long running  processes. :-)

  Laszlo

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: Re: Poor performance on seq scan
Next
From: "Joshua Marsh"
Date:
Subject: Performance With Joins on Large Tables