Re: Help with extracting large volumes of records across related tables

Поиск
Список
Период
Сортировка
От Pierre-Frédéric Caillaud
Тема Re: Help with extracting large volumes of records across related tables
Дата
Msg-id opsd9nztwdcq72hf@musicbox
обсуждение исходный текст
Ответ на Re: Help with extracting large volumes of records across related tables  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список pgsql-performance
My simple python program dumps 1653992 items in 1654000 categories in :

real    3m12.029s
user    1m36.720s
sys     0m2.220s

It was running on the same machine as postgresql (AthlonXP 2500).
I Ctrl-C'd it before it dumped all the database but you get an idea.

If you don't know Python and Generators, have a look !

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

Предыдущее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: Help with extracting large volumes of records across related tables
Следующее
От: "Damien Dougan"
Дата:
Сообщение: Re: Help with extracting large volumes of records across related tables