If you are looking for performance I think letting the caching in the
OS/PostgreSQL take care of keeping stuff in memory is your best bet. But make
sure that you have given it a chance.
Have you already adjusted the settings in postgresql.conf? The default is to
severely limit the resources used by PostgreSQL so that it will at least
start and run run on as many platforms as possible. It is not set by default
to run as fast as possible.
It is assumed (seemingly often incorrectly given the recent thread on
changing the default configuration) that the administrator will adjust the
settings as appropriate for the capacity/requirements of that specific
installation.
Cheers,
Steve
On Tuesday 25 February 2003 6:59 am, Malghan, Ravi wrote:
> What I am trying to do is, I have multiple databases some of which are
> frequently accessed. So I am trying to see if the one's which are
> frequently accessed can be run as memory resident and others run normally.
> I am thinking this might improve response times.