Re: [PERFORM] A Better External Sort?

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: [PERFORM] A Better External Sort?
Дата
Msg-id 1128508373.8561.28.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на Re: [PERFORM] A Better External Sort?  (Ron Peacetree <rjpeace@earthlink.net>)
Список pgsql-hackers
On K, 2005-10-05 at 05:43 -0400, Michael Stone wrote:
> On Tue, Oct 04, 2005 at 12:43:10AM +0300, Hannu Krosing wrote:
> >Just FYI, I run a count(*) on a 15.6GB table on a lightly loaded db and
> >it run in 163 sec. (Dual opteron 2.6GHz, 6GB RAM, 6 x 74GB 15k  disks in
> >RAID10, reiserfs). A little less than 100MB sec.
> 
> And none of that 15G table is in the 6G RAM?

I believe so, as there had been another query running for some time,
doing a select form a 50GB table.

-- 
Hannu Krosing <hannu@skype.net>



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

Предыдущее
От: "R, Rajesh (STSD)"
Дата:
Сообщение: Re: [PERFORM] Query in SQL statement
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [PERFORM] A Better External Sort?