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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-performance by date

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