Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with extracting large volumes of records across related tables - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: Help with extracting large volumes of records across related tables
Date
Msg-id opsd9nztwdcq72hf@musicbox
Whole thread Raw
In response to Re: Help with extracting large volumes of records across related tables  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Help with extracting large volumes of records across related tables
Next
From: "Damien Dougan"
Date:
Subject: Re: Help with extracting large volumes of records across related tables