Gregory S. Williamson wrote: > Nitpicking -- > > Perhaps the 4th data line is meant to be: > Inserts in separate transactions 2500 inserts/second > ^^^^^^^^^^^^^^^^^^^^^^^
Oh, yes, sorry. It is: > Sorry to be replying late. Here is what I found. > > fsync on > Inserts all in one transaction 3700 inserts/second > Inserts in separate transactions 870 inserts/second > > fsync off > Inserts all in one transaction 3700 inserts/second > Inserts in separate transactions 2500 inserts/second -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend