Mark kirkwood wrote:
> Damn... too quick with the "send" button.
>
> I forgot to mention :
>
> 1) the test involved usng copy to load the rows !
Oh, COPY. Remember fsync of WAL only happens at the end of a
transaction, and with COPY, that is only once the table is completely
loaded. No wonder you saw strange results. Also, someone reported ext3
as 50% slower than ext2, so again, your numbers are a surprise.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026