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

Reply via email to