Hello,
I'm currently working with a development database, PostgreSQL 6.5.2 on RedHat 6.1 Linux. There is one fairly large
table(currently ~ 1.3 million rows) which will continue to grow at about 500k rows per week (I'm considering various
optionsto periodically archive or reduce the collected data). Is there anything I can do to cache some or all of this
tablein memory in order to speed queries against it? The physical file is about 130 MB. The server is a dual Pentium
Pro200 with 512 MB of RAM.
Any suggestions would be appreciated.
Joe Conway
p.s. I tried to search the archives, but it did not return any results with even the simplest of searches.