| 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: | Whole Thread | Raw Message | 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 |