Re: O_DIRECT setting - Mailing list pgsql-performance

From Mark Wong
Subject Re: O_DIRECT setting
Date
Msg-id 20040924080703.A27640@osdl.org
Whole thread Raw
In response to O_DIRECT setting  (Guy Thornley <guy@esphion.com>)
Responses Re: O_DIRECT setting
List pgsql-performance
On Mon, Sep 20, 2004 at 07:57:34PM +1200, Guy Thornley wrote:
[snip]
>
> Incidentally, postgres heap files suffer really, really bad fragmentation,
> which affects sequential scan operations (VACUUM, ANALYZE, REINDEX ...)
> quite drastically. We have in-house patches that somewhat alleiviate this,
> but they are not release quality. Has anybody else suffered this?
>

Any chance I could give those patches a try?  I'm interested in seeing
how they may affect our DBT-3 workload, which execute DSS type queries.

Thanks,
Mark

pgsql-performance by date:

Previous
From: Michael Adler
Date:
Subject: Re: Caching of Queries (now with pgpool)
Next
From: Qing Zhao
Date:
Subject: performance of PostgreSQL on 64 bit MAC OS X G5!