yue peng writes:
> I encountered an out of memory error during executing un INSERT into
> table1(v1,v2,v3) SELECT c1,c2,c3 from table2 where .
Most likely the OOM is because of growth of the pending-trigger-event
queue --- do you have any foreign key references in that table?
Possible solut
On 24 March 2010 10:57, yue peng wrote:
> Is there any other ways to still insert same amount of data and avoid this
> OOM error ?
>
>
I'd expect COPY to be the most effective way of bulk loading data into a
database. http://www.postgresql.org/docs/current/static/sql-copy.html
Or do inserts in
Dear, Psqlers,
I encountered an out of memory error during executing un INSERT into
table1(v1,v2,v3) SELECT c1,c2,c3 from table2 where .
The recordset of Select query is around 30M record. And I got following
Message :
--- ERROR: out of memoryDETAIL: Failed on request of size 40.' in
