Re: Config help - Mailing list pgsql-general

From John R Pierce
Subject Re: Config help
Date
Msg-id 4B008862.3000908@hogranch.com
Whole thread Raw
In response to Re: Config help  ("BuyAndRead Test" <test@buyandread.com>)
Responses Re: Config help  (Lew <noone@lwsc.ehost-services.com>)
List pgsql-general
BuyAndRead Test wrote:
> This is a virtual server, so I could give it as much as 8 GB of memory if
> this will give much higher performance. What should shared_buffere be set to
> if I use 8 GB, as much as 4 GB?
>


I'd keep it around 1-2GB shared_buffers, and let the rest of the memory
be used as file system cache.  postgres works quite happily that way.



pgsql-general by date:

Previous
From: "BuyAndRead Test"
Date:
Subject: Re: Config help
Next
From: Thom Brown
Date:
Subject: Re: [pgeu-general] pgday.eu