From: Cyril Ferrand <Cyril.Ferrand@sophia.inria.fr>
To: David Hartwig <daveh@insightdist.com>
Cc: Cyril Ferrand <Cyril.Ferrand@sophia.inria.fr>
Cc: pgsql-interfaces@postgreSQL.org
Cc: Cyril.Ferrand@sophia.inria.fr
Subject: Re: [INTERFACES] perl interface
Date: Fri, 24 Jul 1998 16:27:36 +0200
Message-ID: <199807241427.QAA20633@celia.inria.fr> (raw)
In-Reply-To: <daveh@insightdist.com> <35AF6B60.742B4C46@insightdist.com>
>
>
> Cyril Ferrand wrote:
>
> > Hello
> > Is there someone who use perl interface to postgres to put a lot of data into
> > a base.
> > When my table are 40 meg my perl stop...
> >
>
> I'll take a good guess based on what little information you have provided. I will
> assume the you ran a query which requested a large chunk of that 40 meg table. The perl
> interface uses libpq. And libpq slurps the entire query result into memory before
> passing control back to the users code. This is a weakness of this library. May I
> suggest that you declare a cursor and request the data in chunks. (fetch 100 rows at a
> time) If you use a cursor and fetch only one row at a time you may be disappointed in
> the performance.
>
>
> Hello
in fact i dont make query with my perl script ... i make insert and sometimes
(when table are quite big) my perl script stop but no die....
After i do : perl .... to and my script work until it stop again.
I dont understant why ???
Cyril
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Cyril.Ferrand@sophia.inria.fr, daveh@insightdist.com
Subject: Re: [INTERFACES] perl interface
In-Reply-To: <199807241427.QAA20633@celia.inria.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox