Re: Caching by Postgres - Mailing list pgsql-performance

From Chris Browne
Subject Re: Caching by Postgres
Date
Msg-id 60slx0perm.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Caching by Postgres  (gokulnathbabu manoharan <gokulnathbabu@yahoo.com>)
List pgsql-performance
Donald.Courtney@Sun.COM (Donald Courtney) writes:
> I mean well with this comment -
> This whole issue of data caching is  a troubling issue with postreSQL
> in that even if you ran postgreSQL on a 64 bit address space
> with larger number of CPUs you won't see much of a scale up
> and possibly even a drop.   I am not alone in having the *expectation*
> that a database should have some cache size parameter and
> the option to skip the file system.   If I use oracle, sybase, mysql
> and maxdb they all have the ability to size a data cache and move
> to 64 bits.
>
> Is this a crazy idea - that a project be started to get this
> adopted?  Is it too big and structural to contemplate?

This project amounts to "Implement Your Own Operating System," because
it requires that the DBMS take over the things that operating systems
normally do, like:
 a) Managing access to filesystems and
 b) Managing memory

The world is already sufficiently filled up with numerous variations
of Linux, BSD 4.4 Lite, and UNIX System V; I can't see justification for
reinventing this wheel still again.
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://cbbrowne.com/info/multiplexor.html
Rules of  the Evil Overlord #196.  "I will hire an  expert marksman to
stand by the entrance to my  fortress. His job will be to shoot anyone
who rides up to challenge me."  <http://www.eviloverlord.com/>

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: Caching by Postgres
Next
From: Chris Browne
Date:
Subject: Re: Caching by Postgres