Foreign Data Wrapper out of memory

From: Adeelusman <iq(dot)adeel(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Foreign Data Wrapper out of memory
Date: 2013-05-30 07:34:56
Message-ID: 1369899296363-5757385.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have recently started work with PostgreSQL. Here is my question!
i have a table in oracle and i want to insert all record in PostgreSQL, For
this i'm using Foreign Data Wrapper for oracle. it work fine with small set
of data but as i tried to get large table query got failed after getting 0.5
million records. here is the error "out of memory for query result" can
someone let me know how to avoid this.

One more question I'm on windows environment. i could not get any Foreign
Data Wrapper for oracle for 64bit system. anyone explain this ?

lastly i would like to ask when we create a wrapper table where actually it
is created. it hold the record in memory or physical table. what is the way
if i want to insert all record from Wrapper table to ordinary table

regards

Adeel Usman

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Foreign-Data-Wrapper-out-of-memory-tp5757385.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benedikt Grundmann 2013-05-30 09:37:34 Re: How to upgrade postgres 8.4 -> 9.1 contrib?
Previous Message Alvaro Herrera 2013-05-30 06:24:38 Re: TRIGGER EVENT