Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B3B0D9FB1DF for ; Tue, 16 Jan 2007 05:34:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 41187-10 for ; Tue, 16 Jan 2007 05:33:44 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id F02949FB1C0 for ; Tue, 16 Jan 2007 05:33:52 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1569161ugf for ; Tue, 16 Jan 2007 01:33:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=mByCrGbJGTinz4IZheU8rpQHlPHFgmy6jL7W5PG+wA3mdbM4IPlehuQ1BOzZ/MKKf/G946ABrfDuM7uvTJjNZqIrj5wnBwP5EDdpso3Y+oW744onK24tAx/kVvMqwriXcu9FX2BBjNgDX7WgHxt9haxHaiHPDWylrTSS0fMgO9I= Received: by 10.78.203.13 with SMTP id a13mr638164hug.1168940029540; Tue, 16 Jan 2007 01:33:49 -0800 (PST) Received: from ?192.168.0.39? ( [62.232.55.118]) by mx.google.com with ESMTP id 33sm6112278hue.2007.01.16.01.33.47; Tue, 16 Jan 2007 01:33:48 -0800 (PST) Message-ID: <45AC9BF4.5040802@enterprisedb.com> Date: Tue, 16 Jan 2007 09:33:40 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: ramachandra.bhaskaram@wipro.com CC: pgsql-performance@postgresql.org Subject: Re: Caching in PostgreSQL References: <47230CE166B64744B0120173E4C2161E0103E70C@BLR-EC-MBX01.wipro.com> In-Reply-To: <47230CE166B64744B0120173E4C2161E0103E70C@BLR-EC-MBX01.wipro.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/237 X-Sequence-Number: 22838 ramachandra.bhaskaram@wipro.com 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? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com