X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id CF070D1B7D5
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 15 Jun 2004 17:24:32 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 90201-05
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 15 Jun 2004 20:24:25 +0000 (GMT)
Received: from web53908.mail.yahoo.com (web53908.mail.yahoo.com
	[206.190.36.218])
	by svr1.postgresql.org (Postfix) with SMTP id 73AA7D1B7CC
	for <pgsql-admin@postgresql.org>; Tue, 15 Jun 2004 17:24:22 -0300 (ADT)
Message-ID: <20040615202424.75345.qmail@web53908.mail.yahoo.com>
Received: from [64.81.205.234] by web53908.mail.yahoo.com via HTTP;
	Tue, 15 Jun 2004 13:24:23 PDT
Date: Tue, 15 Jun 2004 13:24:23 -0700 (PDT)
From: ow <oneway_111@yahoo.com>
Subject: Out of memory error
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0
	tests=FROM_ENDS_IN_NUMS
X-Spam-Level: 
X-Archive-Number: 200406/183
X-Sequence-Number: 13843

pg 7.4.2 on RH 7.3

Hi,

Am getting "Out of memory error" and pgSql is getting killed when running the
following statement in psql:

insert into tableA
select * from tableB
where testdate >= '2000-01-01' and testdate <= '2002-12-31'

TableB contains about 120 million records. The insert/select affects about
30-40M.

What's happening is that pgSql gradually takes all (well, almost) physical and
swap memory and then, I think, is getting killed by the kernel.

Qs:

1) Is this normal?
2) Is there anything I can do besides adding more memory to the box? 

Thanks





	
		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail