Alex Turner <armtuk@gmail.com> writes:
> On Apr 1, 2005 4:17 PM, Alex Turner <armtuk@gmail.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