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

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: 2010-01-21 08:35:09
Message-ID: 4B5811BD.4020202@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Carey wrote:
> On Jan 20, 2010, at 5:32 AM, fkater(at)googlemail(dot)com wrote:
>
>
>> In the attachement you'll find 2 screenshots perfmon34.png
>> and perfmon35.png (I hope 2x14 kb is o.k. for the mailing
>> list).
>>
>>

I don't think they made it to the list? I didn't see it, presumably
Scott got a direct copy. I'd like to get a copy and see the graphs even
if takes an off-list message. If it's an 8.2 checkpoint issue, I know
exactly what shapes those take in terms of the disk I/O pattern.

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2010-01-21 11:13:42 Re: ext4 finally doing the right thing
Previous Message Scott Carey 2010-01-21 08:25:41 Re: Inserting 8MB bytea: just 25% of disk perf used?