Re: [GENERAL] importance of bgwriter_percent

2005-04-01 Thread vinita bansal
Re: [GENERAL] importance of bgwriter_percent Date: Fri, 01 Apr 2005 09:43:38 -0600 On Fri, 2005-04-01 at 00:36, vinita bansal wrote: > Hi, > > I have a 64 bit Linux box with 64GB RAM and 450GB HDD. I am running a > benchmark on database of size 40GB using the following settings: > - da

Re: [GENERAL] importance of bgwriter_percent

2005-04-01 Thread Scott Marlowe
On Fri, 2005-04-01 at 00:36, vinita bansal wrote: > Hi, > > I have a 64 bit Linux box with 64GB RAM and 450GB HDD. I am running a > benchmark on database of size 40GB using the following settings: > - data=writeback You might want to read this post about ext3 with writeback: http://archives.pos

[GENERAL] importance of bgwriter_percent

2005-03-31 Thread vinita bansal
Hi, I have a 64 bit Linux box with 64GB RAM and 450GB HDD. I am running a benchmark on database of size 40GB using the following settings: - data=writeback - Moved wal logs to seperate partition - settings in postgresql.conf: shared_buffers = 10 work_mem = 10 maintenance_