pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ashish Karalkar <ashishka@synechron.com>
To: Siddharth Shah <siddharth.shah@elitecore.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Shared Buffers
Date: Mon, 02 Mar 2009 19:01:33 +0530
Message-ID: <49ABDFB5.4090709@synechron.com> (raw)
In-Reply-To: <49ABDB1F.2020208@elitecore.com>
References: <49ABDB1F.2020208@elitecore.com>

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

view thread (17+ messages)  latest in thread

Message-ID: <49ABDFB5.4090709@synechron.com>
Permalink:  ../49ABDFB5.4090709@synechron.com/
Also on:    postgresql.org/message-id/49ABDFB5.4090709@synechron.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: ashishka@synechron.com, siddharth.shah@elitecore.com
  Subject: Re: Shared Buffers
  In-Reply-To: <49ABDFB5.4090709@synechron.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox