I tried with less tables
and it works now
thanks again for your help ....
Tom Lane <tgl@sss.pgh.pa.us>
22/02/2006 15:58
Pour : Prestation3.EXPLOITATION@nexans.com
cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] Out of memory using ora2pg
Prestation3.EXPLOITATION@nexans.com writes:
> Dumping table TRANSACTIONS...
> ........................................................DBD::Pg::st
> execute failed: ERROR: out of memory
> DETAIL: Failed on request of size 16.
> ERROR: out of memory
> DETAIL: Failed on request of size 16.
> Is it a problem with perl memory or posgresql memory ?
Given the spelling of the error message, that's coming from the server
side (I don't think we have any client-side code that uses DETAIL lines).
What is the exact SQL query that's being executed here? (If you don't
know, try enabling query logging in the server so you can find out.)
You should be able to replicate the failure by entering the same query
via psql. If so, let's see the output of EXPLAIN for the query.
regards, tom lane