Re: Shared Buffers - Mailing list pgsql-general

From Ashish Karalkar
Subject Re: Shared Buffers
Date
Msg-id 49ABDFB5.4090709@synechron.com
Whole thread Raw
In response to Shared Buffers  (Siddharth Shah <siddharth.shah@elitecore.com>)
Responses Re: Shared Buffers  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Siddharth Shah
Date:
Subject: Shared Buffers
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Shared Buffers