From: Jim C. Nasby <jim@nasby.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Guy Thornley <guy@esphion.com>
Cc: Markus Schaber <schabi@logix-tt.com>
Cc: Luke Lonergan <llonergan@greenplum.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Large tables (was: RAID 0 not as fast as
Date: Fri, 22 Sep 2006 09:02:29 -0500
Message-ID: <20060922140228.GX28987@nasby.net> (raw)
In-Reply-To: <200609220305.k8M35dI10346@momjian.us>
References: <20060922025209.GO6211@esphion.com>
<200609220305.k8M35dI10346@momjian.us>
On Thu, Sep 21, 2006 at 11:05:39PM -0400, Bruce Momjian wrote:
> We tried posix_fadvise() during the 8.2 development cycle, but had
> problems as outlined in a comment in xlog.c:
>
> /*
> * posix_fadvise is problematic on many platforms: on older x86 Linux
> * it just dumps core, and there are reports of problems on PPC platforms
> * as well. The following is therefore disabled for the time being.
> * We could consider some kind of configure test to see if it's safe to
> * use, but since we lack hard evidence that there's any useful performance
> * gain to be had, spending time on that seems unprofitable for now.
> */
In case it's not clear, that's a call for someone to do some performance
testing. :)
Bruce, you happen to have a URL for a patch to put fadvise in?
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: jim@nasby.net, bruce@momjian.us, guy@esphion.com, schabi@logix-tt.com, llonergan@greenplum.com
Subject: Re: Large tables (was: RAID 0 not as fast as
In-Reply-To: <20060922140228.GX28987@nasby.net>
* 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