Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 49F51633346 for ; Mon, 2 Mar 2009 09:31:47 -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 32781-05 for ; Mon, 2 Mar 2009 09:31:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail2.Synechron.com (mail2.synechron.com [220.225.40.41]) by mail.postgresql.org (Postfix) with ESMTP id CA4DB632FC5 for ; Mon, 2 Mar 2009 09:31:42 -0400 (AST) Received: from [10.31.15.20] [10.31.15.20] by mail2.Synechron.com with ESMTP (SMTPD-9.10) id AFDC258DAC; Mon, 02 Mar 2009 19:02:12 +0530 Message-ID: <49ABDFB5.4090709@synechron.com> Date: Mon, 02 Mar 2009 19:01:33 +0530 From: Ashish Karalkar User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Siddharth Shah CC: pgsql-general@postgresql.org Subject: Re: Shared Buffers References: <49ABDB1F.2020208@elitecore.com> In-Reply-To: <49ABDB1F.2020208@elitecore.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.431 tagged_above=0 required=5 tests=DNS_FROM_OPENWHOIS=2.431 X-Spam-Level: ** X-Archive-Number: 200903/9 X-Sequence-Number: 144596 Siddharth Shah wrote: > > 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 Take a look at http://www.westnet.com/~gsmith/content/postgresql/InsideBufferCache.pdf http://postgresql.mirrors-r-us.net/files/documentation/books/aw_pgsql/hw_performance/node3.html --Ashish