Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group