Re: [INTERFACES] perl interface

>
>
> 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