I tried with less tables
and it works now
thanks again for your help ....
Tom Lane <[EMAIL PROTECTED]>
22/02/2006 15:58
Pour : [EMAIL PROTECTED]
cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] Out of memory using ora2pg
[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
