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

Re: [PERFORM] A Better External Sort?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Ron Peacetree <rjpeace(at)earthlink(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] A Better External Sort?
Date: 2005-09-30 17:23:30
Message-ID: 433D7492.7000307@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Ron,

> Hmmm.
> 60GB/5400secs= 11MBps.  That's ssllooww.  So the first
> problem is evidently our physical layout and/or HD IO layer
> sucks.

Actually, it's much worse than that, because the sort is only dealing 
with one column.  As I said, monitoring the iostat our top speed was 
2.2mb/s.

--Josh

In response to

pgsql-performance by date

Next:From: Dann CorbitDate: 2005-09-30 17:44:34
Subject: Re: [PERFORM] A Better External Sort?
Previous:From: Richard HuxtonDate: 2005-09-30 09:34:35
Subject: Re: Lists or external TABLE?

pgsql-hackers by date

Next:From: Tony CadutoDate: 2005-09-30 17:41:48
Subject: Re: Found small issue with OUT params
Previous:From: Thomas HallgrenDate: 2005-09-30 16:12:03
Subject: Re: Socket problem using beta2 on Windows-XP

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