Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Mon, Sep 20, 2004 at 07:57:34PM +1200, Guy Thornley wrote:
> 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.


In response to


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group