yue peng <pengyuebupt@xxxxxxxxx> 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 solutions are to insert fewer rows at a time, or to drop the FK constraint and then re-create it after you do the bulk insertion. You might also try updating to a newer PG version ... 8.4 and later use only 12 bytes per pending INSERT trigger not 40. That's not necessarily going to be enough to fix this particular case, of course. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
