| 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 |
| Message-ID: | 29021.1112393033@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| 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? |