Re: [ADMIN] Re out of memory error with large insert

2006-03-23 Thread Sriram Dandapani
about 5 shared_buffers I would really appreciate any help ... Thanks Sriram -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 7:24 PM To: Sriram Dandapani Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Re out of memory error with large

Re: [ADMIN] Re out of memory error with large insert

2006-03-21 Thread Tom Lane
"Sriram Dandapani" <[EMAIL PROTECTED]> writes: > Why doesn't Postgres use swap in this situation Perhaps you need to adjust the ulimit settings that the postmaster is started under. regards, tom lane ---(end of broadcast)---

[ADMIN] Re out of memory error with large insert

2006-03-21 Thread Sriram Dandapani
-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 does