> Did you try mounting ext3 whith data=writeback by chance? People have
> found that makes a big difference in performance.
I'm not sure, there's other people here doing the OS stuff - I'm pretty
much ignorant about what "data=writeback" could mean :-D
They knew however that for the data partitions no FS journaling is
needed, and for the WAL partition meta data journaling is enough, so I
guess they tuned ext3 for this.
In response to
pgsql-performance by date
|Next:||From: Steinar H. Gunderson||Date: 2006-03-21 11:56:18|
|Subject: Re: Migration study, step 1: bulk write performance|
|Previous:||From: Jim C. Nasby||Date: 2006-03-21 11:51:00|
|Subject: Re: planner with index scan cost way off actual cost,|