Re: Poor performance on seq scan

From: Laszlo Nagy <gandalf(at)designaproduct(dot)biz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance on seq scan
Date: 2006-09-12 21:49:21
Message-ID: 45072B61.3080506@designaproduct.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua Marsh 2006-09-12 22:17:34 Performance With Joins on Large Tables
Previous Message Craig A. James 2006-09-12 21:05:52 Re: Poor performance on seq scan