Re: [PERFORM] Caching in PostgreSQL

2007-01-16 Thread Chris Browne
[EMAIL PROTECTED] writes: > Can anybody tell me how can I implement data Caching in the > shared memory using PostgreSQL. PostgreSQL already does that. Implementing this functionality is rather tricky: Between version 7.4 and now, it has seen *massive* change which has required a great deal

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 per

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 t

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 Postgr

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? -- Hei

[PERFORM] Caching in PostgreSQL

2007-01-16 Thread ramachandra.bhaskaram
Hi, Can anybody tell me how can I implement data Caching in the shared memory using PostgreSQL. For one of the projects we are using Postgres version 8.0.3 and were planning to support table partitioning in order to improve the DB query/update performance but, it will be very m