Caching in PostgreSQL

From: <ramachandra(dot)bhaskaram(at)wipro(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Caching in PostgreSQL
Date: 2007-01-16 08:43:21
Message-ID: 47230CE166B64744B0120173E4C2161E0103E70C@BLR-EC-MBX01.wipro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance



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 much helpful if anybody
can tell me whether data cache is possible in Postgres.

We also, need to know if the DB view is kept in the DB Managers program
memory or in the shared memory of the processor. If it is in the shared
memory, we only need to know the shared memory address/name so that we
can access. If not in shared memory then we need know whether it is
possible to make the postgress to store the DB view in shared memory.

Thanks in Advance,
Ram.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-01-16 09:33:40 Re: Caching in PostgreSQL
Previous Message Andrew Hammond 2007-01-15 17:55:47 FiberChannel cards for FreeBSD on AMD64