2011/5/28 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 g
2011/5/31 Toby Corkindale :
> On 30/05/11 20:41, Cédric Villemain wrote:
>>
>> 2011/5/30 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 o
On 30/05/11 20:41, Cédric Villemain wrote:
2011/5/30 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 an
2011/5/30 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
>> calc
Thanks Toby, I will check it, and change it.
regards,
Carl
2011/5/30 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 w
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
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
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 https://github.com/gregs11
Hi Carl,
Thank you for your response, however, I am trying to understand the role of
shared_buffer. I notice you have increased this value in your settings.
I am just trying to understand the meaning of this statement-
"PostgreSQL depends on the OS for caching. (
http://www.varlena.com/GeneralBit
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 (
http:/
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 G
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 wrote:
> Hi All,
>
> I am little confused about the internal working of PostgreSQL. There is a
> param
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 vict
13 matches
Mail list logo
