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.