Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9E022633670 for ; Mon, 2 Mar 2009 09:16:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16778-10 for ; Mon, 2 Mar 2009 09:16:14 -0400 (AST) X-Greylist: delayed 00:06:40.745941 by SQLgrey-1.7.6 Received: from elitecore.com (mailhost.elitecore.com [203.88.135.194]) by mail.postgresql.org (Postfix) with ESMTP id DA4CE63342D for ; Mon, 2 Mar 2009 09:16:12 -0400 (AST) Received: (qmail 15480 invoked from network); 2 Mar 2009 12:50:19 -0000 Received: from ice.140.client119.youtele.com (HELO [192.168.1.136]) (siddharth.shah@[203.88.140.119]) (envelope-sender ) by elitecore.com (qmail-ldap-1.03) with SMTP for ; 2 Mar 2009 12:50:19 -0000 Message-ID: <49ABDB1F.2020208@elitecore.com> Date: Mon, 02 Mar 2009 18:41:59 +0530 From: Siddharth Shah User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Shared Buffers Content-Type: multipart/alternative; boundary="------------040803030105090903040207" X-Cyberoam-Version: 9.5.8.42 X-Cyberoam-smtpxy-version: 1.0.5.3 X-Cyberoam-AV-Status: Clean X-Cyberoam-Proto: SMTP X-Cyberoam-AV-Policy: None X-CTCH-PVer: 0000001 X-CTCH-Spam: Unknown X-CTCH-VOD: Unknown X-CTCH-Flags: 0 X-CTCH-RefID: str=0001.0A150204.49ABDA86.001A,ss=1,fgs=0 X-Cyberoam-AS-Policy: None X-Cyberoam-Version: 9.5.8.52 X-Cyberoam-smtpxy-version: 1.0.5.3 X-Cyberoam-AV-Status: Clean X-Cyberoam-Proto: SMTP X-Cyberoam-AV-Policy: None X-CTCH-PVer: 0000001 X-CTCH-Spam: Unknown X-CTCH-VOD: Unknown X-CTCH-Flags: 0 X-CTCH-RefID: str=0001.0A150202.49ABDA86.0080,ss=1,fgs=0 X-Cyberoam-AS-Policy: None X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/8 X-Sequence-Number: 144595 This is a multi-part message in MIME format. --------------040803030105090903040207 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello All, How Postgres Maintains data in Shared Buffer Does It maintains queried data in memory or table data and Next time how postgres fetch data from memory rather than disk Which algorithm is used for storing data how data is indexed in shared buffers Thanks Siddharth --------------040803030105090903040207 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
Hello All,
How Postgres Maintains data in Shared Buffer

Does It maintains queried data in memory or table data and Next time how postgres fetch data from memory
rather than disk
Which algorithm is used for storing data how data is indexed in shared buffers

Thanks
Siddharth
--------------040803030105090903040207--