Re: [PERFORM] Caching in PostgreSQL

2007-01-16 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: Hi, Can anybody tell me how can I implement data Caching in the shared memory using PostgreSQL. PostgreSQL, like most other DBMS, caches data pages in shared memory. What exactly are you trying to accomplish? Are you having a performance problem? --

Re: [PERFORM] Caching in PostgreSQL

2007-01-16 Thread ramachandra.bhaskaram
. -Original Message- From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] On Behalf Of Heikki Linnakangas Sent: Tuesday, January 16, 2007 3:04 PM To: Ramachandra Bhaskaram (WT01 - IP-Multimedia Carrier Ent Networks) Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Caching in PostgreSQL

Re: [PERFORM] Caching in PostgreSQL

2007-01-16 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: We were looking on how to improve the performance of our application which is using PostgreSQL as backend.If postgreSQL is supporting data page caching in the shared memory then we wanted to design our application to read/write using the shared memory rather

Re: [PERFORM] Caching in PostgreSQL

2007-01-16 Thread David Levy
I am using memcached (http://www.danga.com/memcached/) to cache Postgres ADODB recordsets. It's very efficient but has to be implemented in your own application. On 1/16/07, Heikki Linnakangas [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: We were looking on how to improve the