"Manos Tsagias" <[EMAIL PROTECTED]> writes: > I used COPY to import a 2GB CSV file into a table. After almost 2 hours I > got: > ERROR: out of memory
Looks like you're running out of memory for pending AFTER trigger events. What triggers or foreign keys have you got on that table? The usual recommendation for bulk loading into a table with a foreign key is to drop the FK constraint, bulk load, re-create the FK constraint. This will be significantly faster than allowing the FK to be checked incrementally. Yeah, it'd be nice if that were automated for you ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings