pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laszlo Nagy <gandalf@designaproduct.biz>
To: pgsql-performance@postgresql.org
Subject: Re: Poor performance on seq scan
Date: Tue, 12 Sep 2006 23:49:21 +0200
Message-ID: <45072B61.3080506@designaproduct.biz> (raw)
In-Reply-To: <45072130.6020508@modgraph-usa.com>
References: <450684EC.4090304@designaproduct.biz>
	<17034.1158079926@sss.pgh.pa.us>
	<45072130.6020508@modgraph-usa.com>

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




view thread (26+ messages)  latest in thread

Message-ID: <45072B61.3080506@designaproduct.biz>
Permalink:  ../45072B61.3080506@designaproduct.biz/
Also on:    postgresql.org/message-id/45072B61.3080506@designaproduct.biz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gandalf@designaproduct.biz
  Subject: Re: Poor performance on seq scan
  In-Reply-To: <45072B61.3080506@designaproduct.biz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox