Re: [HACKERS] sort on huge table

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: [HACKERS] sort on huge table
Дата
Msg-id
Pine.GSO.4.02A.9911301910030.13278-100000@Vessla.DoCS.UU.SE
Ответ на
Список
Дерево обсуждения
Re: [HACKERS] sort on huge table Hannu Krosing <hannu@tm.ee>
I ran the sort script without change, the resulting file was about 250MB
in size. Not sure what kind of sizes you were looking for.

6.5.3     696.01 real         0.03 user         0.02 sys

"7.0" from last Saturday     957.73 real         0.03 user         0.02 sys
one more time     936.41 real         0.04 user         0.01 sys


FreeBSD 3.3, 200MHz Pentium (P55C), 128MB RAM
both installations where done without extras (bare ./configure)

That almost seems too wacko to be true. I'll be happy to rerun them, with
other sizes if you want.

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden






В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
FAQ