Re: O_DIRECT setting

From: Mark Wong <markw(at)osdl(dot)org>
To: Guy Thornley <guy(at)esphion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: O_DIRECT setting
Date: 2004-09-24 15:07:03
Message-ID: 20040924080703.A27640@osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Qing Zhao 2004-09-24 19:23:03 performance of PostgreSQL on 64 bit MAC OS X G5!
Previous Message Michael Adler 2004-09-24 02:00:59 Re: Caching of Queries (now with pgpool)