Re: Inserting 8MB bytea: just 25% of disk perf used?

From: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
To: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: 2010-01-18 16:38:44
Message-ID: 20100118163844.GH2913@comppasch2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

fkater(at)googlemail(dot)com:

> I'll try to execute these tests on a SSD
> and/or Raid system.

FYI:

On a recent but mid-range performing SSD (128 MB size,
serially writing 80-140 MB, 100 MB average) the situation
was worse for some reason. No difference by fsync=on/off.

Felix

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-01-18 17:13:24 Re: Bad plan choice nestloop vs. hashjoin
Previous Message Greg Stark 2010-01-18 16:35:59 Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)