Re: Anything to be gained from a 'Postgres Filesystem'? - Mailing list pgsql-performance

From Neil Conway
Subject Re: Anything to be gained from a 'Postgres Filesystem'?
Date
Msg-id 1099628919.10449.39.camel@localhost.localdomain
Whole thread Raw
In response to Re: Anything to be gained from a 'Postgres Filesystem'?  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
On Fri, 2004-11-05 at 06:20, Steinar H. Gunderson wrote:
> You mean, like, open(filename, O_DIRECT)? :-)

This disables readahead (at least on Linux), which is certainly not we
want: for the very case where we don't want to keep the data in cache
for a while (sequential scans, VACUUM), we also want aggressive
readahead.

-Neil



pgsql-performance by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Next
From: Neil Conway
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?