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: 20040924080703.A27640@osdl.org (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group