Re: [PERFORM] A Better External Sort?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [PERFORM] A Better External Sort?
Дата
Msg-id 433D7492.7000307@agliodbs.com
обсуждение исходный текст
Ответ на Re: [PERFORM] A Better External Sort?  (Ron Peacetree <rjpeace@earthlink.net>)
Список pgsql-hackers
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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Re: Socket problem using beta2 on Windows-XP
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: Found small issue with OUT params