Re: [GENERAL] Config help

2009-11-16 Thread Lew
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? John R Pierce wrote: I'd keep it around 1-2GB shared_buffers, and let the rest of the m

Re: [GENERAL] Config help

2009-11-15 Thread John R Pierce
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 f

Re: [GENERAL] Config help

2009-11-15 Thread BuyAndRead Test
sql.org > Emne: Re: [GENERAL] Config help > > On Sun, Nov 15, 2009 at 2:43 PM, BuyAndRead Test > wrote: > > Hi > > > > I need some help with our postgresql.conf file. I would appreciate if > > someone could look at the values and tell me if it looks alright or > if

Re: [GENERAL] Config help

2009-11-15 Thread Scott Marlowe
On Sun, Nov 15, 2009 at 2:43 PM, BuyAndRead Test wrote: > Hi > > I need some help with our postgresql.conf file. I would appreciate if > someone could look at the values and tell me if it looks alright or if I > need to change anything. > > The db server has 4 GB of memory and one quad core CPU (2

[GENERAL] Config help

2009-11-15 Thread BuyAndRead Test
Hi I need some help with our postgresql.conf file. I would appreciate if someone could look at the values and tell me if it looks alright or if I need to change anything. The db server has 4 GB of memory and one quad core CPU (2,53 GHz). The hard drives is on a iSCSI array and is configured as f