-----Original Message----- From: Sriram Dandapani Sent: Tuesday, March 21, 2006 4:01 PM To: 'Tom Lane' Subject: RE: [ADMIN] out of memory error with large insert
Upon monitoring with top, the insert statement process keeps eating up memory until there is nothing left on the linux box Why doesn't Postgres use swap in this situation Can we control this behavior thru postgresconf.sql -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 2:38 PM To: Sriram Dandapani Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] out of memory error with large insert "Sriram Dandapani" <[EMAIL PROTECTED]> writes: > On a large transaction involving an insert of 8 million rows, after a > while Postgres complains of an out of memory error. If there are foreign-key checks involved, try dropping those constraints and re-creating them afterwards. Probably faster than retail checks anyway ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
