Réf. : Re: Out of memory using ora2pg

Поиск
Список
Период
Сортировка
От Prestation3.EXPLOITATION@nexans.com
Тема Réf. : Re: Out of memory using ora2pg
Дата
Msg-id OF39C1D67B.941D101B-ONC125711D.0054FCB1-C125711D.0055113A@NEXANS.COM
обсуждение исходный текст
Список pgsql-general
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





В списке pgsql-general по дате отправления:

Предыдущее
От: "Ets ROLLAND"
Дата:
Сообщение: PG 8 stop working !?
Следующее
От: jason.ctr.alburger@faa.gov
Дата:
Сообщение: Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"