Quoth rmalghan(at)btspartners(dot)com ("Malghan, Ravi"):
> 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.
In the ancient past, people would "set the sticky bit" on executable
programs to force them to stay in memory; that idea has become
obsolete what with larger memory sizes and more sophisticated memory
management schemes in Unix variants. I think you're essentially
trying to express the same idea here...
The tables/databases that are frequently accessed should already be
mostly in memory as a result of the way your OS caches data.
It's not likely that there's anything that you can do "inside
PostgreSQL" that would be helpful in this regard.
output = ("cbbrowne" "@acm.org")
"Though the Chinese should adore APL, it's FORTRAN they put their
money on." -- Alan Perlis
In response to
pgsql-general by date
|Next:||From: Dennis Gearon||Date: 2003-02-25 20:17:27|
|Previous:||From: Christopher Browne||Date: 2003-02-25 20:06:16|
|Subject: Re: Can postgresql be run in memory (like a memory resident program)|