[EMAIL PROTECTED] writes: >> Just out of interest, what happens to the difference if you use *ext3* >> (perhaps with data=writeback) > > Actually, I was working for a client, so it wasn't a general exploritory, > but I can say that early on we discovered that ext3 was about the worst > file system for PostgreSQL. We gave up on it and decided to use ext2.
I'd be interested in which ext3 mount options you used--I can see how anything other than 'data=writeback' could be a performance killer. I've been meaning to run a few tests myself, but haven't had the time... -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend