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

Re: adding support for posix_fadvise()

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: adding support for posix_fadvise()
Date: 2003-11-03 14:16:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Mon, Nov 03, 2003 at 08:50:00AM -0500, Neil Conway wrote:

> pool or the kernel's page cache. We can implement the former easily
> enough, but I don't see any feasible way to do the latter: on a high-end
> machine with gigabytes of RAM but a relatively small shared_buffers
> (which is the configuration we recommend), there may be plenty of hot

I wonder if the limitations that are on one's ability to evaluate
effectively what is in the OS's filesystem cache is the real reason
all those Other systems (of Databases, Big, too) have stayed with
their old design of managing it all themselves (raw filesystems and
all the buffering handled by the back end).  Maybe that's not just an
historical argument whereby they happen to have the code around. 
After all, it can't be cheap to maintain.  Not that I'm advocating
writing such a system -- I sure couldn't do the work, to begin with.


Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110

In response to

pgsql-hackers by date

Next:From: Jan WieckDate: 2003-11-03 14:35:57
Subject: Re: Experimental patch for inter-page delay in VACUUM
Previous:From: Neil ConwayDate: 2003-11-03 14:00:34
Subject: equal() perf tweak

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