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.