Re: Inserting 8MB bytea: just 25% of disk perf used? - Mailing list pgsql-performance

From Scott Carey
Subject Re: Inserting 8MB bytea: just 25% of disk perf used?
Date
Msg-id FFDFFE4C-A683-4168-B544-951A6150233E@richrelevance.com
Whole thread Raw
In response to Re: Inserting 8MB bytea: just 25% of disk perf used?  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
On Jan 21, 2010, at 12:35 AM, Greg Smith wrote:

> Scott Carey wrote:
>> On Jan 20, 2010, at 5:32 AM, fkater@googlemail.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.
>

I got the images directly from the email, from the list.
So .... ???


> --
> Greg Smith    2ndQuadrant   Baltimore, MD
> PostgreSQL Training, Services and Support
> greg@2ndQuadrant.com  www.2ndQuadrant.com
>


pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Next
From: Scott Carey
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?