Re: Sustained inserts per sec ... ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Turner <armtuk(at)gmail(dot)com>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sustained inserts per sec ... ?
Date: 2005-04-01 22:03:53
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

Alex Turner <armtuk(at)gmail(dot)com> writes:
> On Apr 1, 2005 4:17 PM, Alex Turner <armtuk(at)gmail(dot)com> wrote:
>> 1250/sec with record size average is 26 bytes
>> 800/sec with record size average is 48 bytes.
>> 250/sec with record size average is 618 bytes.

> Oh - this is with a seperate transaction per command.
> fsync is on.

[ raised eyebrow... ] What kind of disk hardware is that exactly, and
does it have write cache enabled? It's hard to believe those numbers
if not.

Write caching is fine if it's done in a battery-backed cache, which you
can get in the higher-end hardware RAID controllers. Otherwise you're
going to have problems whenever the power goes away unexpectedly.

regards, tom lane

In response to


Browse pgsql-performance by date

  From Date Subject
Next Message Mike Nolan 2005-04-01 22:36:47 Re: Sustained inserts per sec ... ?
Previous Message Vivek Khera 2005-04-01 21:23:13 Re: Follow-Up: How to improve db performance with $7K?