Re: [ADMIN] Postgres Cache usage

2012-09-19 Thread Craig Ringer
On 09/20/2012 12:36 AM, A J wrote: Hi, I have a read heavy application. I would want it to read from memory as database latency has to be in low milliseconds. The database is not too big in size and can be fully contained in memory. With Postgres, if I cache all the tables (by pre-emptive queryi

Re: [ADMIN] Postgres Cache usage

2012-09-19 Thread Steve Crawford
On 09/19/2012 09:36 AM, A J wrote: Hi, I have a read heavy application. I would want it to read from memory as database latency has to be in low milliseconds. The database is not too big in size and can be fully contained in memory. With Postgres, if I cache all the tables (by pre-emptive quer

[ADMIN] Postgres Cache usage

2012-09-19 Thread A J
Hi, I have a read heavy application. I would want it to read from memory as database latency has to be in low milliseconds. The database is not too big in size and can be fully contained in memory. With Postgres, if I cache all the tables (by pre-emptive querying such as select * from tables); i