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: | 20031103141637.GB12457@libertyrms.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2003-11-03 14:35:57 | Re: Experimental patch for inter-page delay in VACUUM |
Previous Message | Neil Conway | 2003-11-03 14:00:34 | equal() perf tweak |