From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
Cc: | Matt Clark <matt(at)ymogen(dot)net>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hardware recommendations to scale to silly load |
Date: | 2003-09-10 16:06:52 |
Message-ID: | 200309101606.h8AG6qR04095@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-09-10 17:16:14 | Re: Reading data in bulk - help? |
Previous Message | Hannu Krosing | 2003-09-10 15:05:35 | Re: Need advice about triggers |