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

From: Scott Carey <scott(at)richrelevance(dot)com>
To: Greg Smith <greg(at)2ndquadrant(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-23 02:51:24
Message-ID: FFDFFE4C-A683-4168-B544-951A6150233E@richrelevance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.
>

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

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

In response to

Browse pgsql-performance by date

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