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

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

pgsql-performance by date

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

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