Re: Hardware recommendations to scale to silly load - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Hardware recommendations to scale to silly load
Date
Msg-id 200309101606.h8AG6qR04095@candle.pha.pa.us
Whole thread Raw
In response to Re: Hardware recommendations to scale to silly load  ("Gregory S. Williamson" <gsw@globexplorer.com>)
List pgsql-performance
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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: "Magnus Naeslund(w)"
Date:
Subject: Re: Reading data in bulk - help?
Next
From: Hannu Krosing
Date:
Subject: Re: Need advice about triggers