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  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы initdb.sh fixed  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
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
Дата:
Сообщение: Re: Ownership/protection (was Re: [HACKERS] Portability)
Следующее
От: Ian Macdonald
Дата:
Сообщение: Re: [HACKERS] perl-DBD-Pg (was Re: BOUNCE pgsql-ports@postgreSQL.org: Non-member submission from[Joe Brenner ] (fwd))