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

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help with extracting large volumes of records across related tables
Date: 2004-09-13 13:05:43
Message-ID: opsd9nztwdcq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 !

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Damien Dougan 2004-09-13 13:44:45 Re: Help with extracting large volumes of records across related tables
Previous Message Pierre-Frédéric Caillaud 2004-09-13 13:01:49 Re: Help with extracting large volumes of records across related tables