Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 30 Sep 2005 10:23:30 -0700
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
- References:
- Re: [PERFORM] A Better External Sort?
- From: Ron Peacetree
- Re: [PERFORM] A Better External Sort?
- Prev by Date: Re: Socket problem using beta2 on Windows-XP
- Next by Date: Re: Found small issue with OUT params
- Previous by thread: Re: [PERFORM] A Better External Sort?
- Next by thread: Re: [PERFORM] A Better External Sort?
- Indexes: