Re: [GENERAL] Shared Buffer Size

2011-05-31 Thread Cédric Villemain
2011/5/31 Toby Corkindale toby.corkind...@strategicdata.com.au: On 30/05/11 20:41, Cédric Villemain wrote: 2011/5/30 Toby Corkindaletoby.corkind...@strategicdata.com.au: On 28/05/11 18:42, Carl von Clausewitz wrote: a few months ago, when I installed my first PostgreSQL, I have had the

Re: [GENERAL] Shared Buffer Size

2011-05-31 Thread Cédric Villemain
2011/5/28 Carl von Clausewitz clausewit...@gmail.com: Hi Preetika, a few months ago, when I installed my first PostgreSQL, I have had the same problem. I've try to get any information about optimal memory config, and working, but there wasn't any optimal memory setting calculator on the

Re: [GENERAL] Shared Buffer Size

2011-05-30 Thread Carl von Clausewitz
Thanks Toby, I will check it, and change it. regards, Carl 2011/5/30 Toby Corkindale toby.corkind...@strategicdata.com.au On 28/05/11 18:42, Carl von Clausewitz wrote: a few months ago, when I installed my first PostgreSQL, I have had the same problem. I've try to get any information about

Re: [GENERAL] Shared Buffer Size

2011-05-30 Thread Cédric Villemain
2011/5/30 Toby Corkindale toby.corkind...@strategicdata.com.au: On 28/05/11 18:42, Carl von Clausewitz wrote: a few months ago, when I installed my first PostgreSQL, I have had the same problem. I've try to get any information about optimal memory config, and working, but there wasn't any

Re: [GENERAL] Shared Buffer Size

2011-05-30 Thread Toby Corkindale
On 30/05/11 20:41, Cédric Villemain wrote: 2011/5/30 Toby Corkindaletoby.corkind...@strategicdata.com.au: On 28/05/11 18:42, Carl von Clausewitz wrote: a few months ago, when I installed my first PostgreSQL, I have had the same problem. I've try to get any information about optimal memory

Re: [GENERAL] Shared Buffer Size

2011-05-29 Thread Toby Corkindale
On 28/05/11 18:42, Carl von Clausewitz wrote: a few months ago, when I installed my first PostgreSQL, I have had the same problem. I've try to get any information about optimal memory config, and working, but there wasn't any optimal memory setting calculator on the internet, just some guide in

Re: [GENERAL] Shared Buffer Size

2011-05-28 Thread Carl von Clausewitz
Hi Preetika, a few months ago, when I installed my first PostgreSQL, I have had the same problem. I've try to get any information about optimal memory config, and working, but there wasn't any optimal memory setting calculator on the internet, just some guide in the posgre documentation (

Re: [GENERAL] Shared Buffer Size

2011-05-28 Thread Greg Smith
On 05/28/2011 04:42 AM, Carl von Clausewitz wrote: I've try to get any information about optimal memory config, and working, but there wasn't any optimal memory setting calculator on the internet, just some guide in the posgre documentation There's a simple one at

Re: [GENERAL] Shared Buffer Size

2011-05-28 Thread Greg Smith
On 05/27/2011 05:33 PM, preetika tyagi wrote: Hows does the shared buffer in Postgres rely on the Operating System cache? Suppose my RAM is 8 GB and shared_buffer is 24 MB in postgres. And there are some dirty pages in shared_buffer and I need to write a dirty page back to the disk to bring in

[GENERAL] Shared Buffer Size

2011-05-27 Thread preetika tyagi
Hi All, I am little confused about the internal working of PostgreSQL. There is a parameter shared_buffer in postgres.conf and I am assuming that it is used for buffer management in PostgreSQL. If there is a need to bring in a new page in the buffer and size exceeds the shared_buffer limit, a

Re: [GENERAL] Shared Buffer Size

2011-05-27 Thread Derrick Rice
Check out the Inside the PostgreSQL Buffer Cache link here: http://projects.2ndquadrant.com/talks Thanks to Greg Smith (active here). Derrick On Fri, May 27, 2011 at 3:36 PM, preetika tyagi preetikaty...@gmail.comwrote: Hi All, I am little confused about the internal working of PostgreSQL.

Re: [GENERAL] Shared Buffer Size

2011-05-27 Thread preetika tyagi
Hi Derrick, Thank you for your response. I saw this document and trying to understand Interaction with the Operating System Cache which is mentioned in this document. I have the following question- Hows does the shared buffer in Postgres rely on the Operating System cache? Suppose my RAM is 8 GB