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 C64A88B9BD0 for ; Fri, 4 Feb 2005 21:39:36 +0000 (GMT) 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 48962-05 for ; Fri, 4 Feb 2005 21:39:24 +0000 (GMT) Received: from omr3.netsolmail.com (omr3.netsolmail.com [216.168.230.164]) by svr1.postgresql.org (Postfix) with ESMTP id 73CC68B9B57 for ; Fri, 4 Feb 2005 21:39:25 +0000 (GMT) Received: from ms9.netsolmail.com (IDENT:mirapoint@[216.168.230.183]) by omr3.netsolmail.com (8.12.10/8.12.10) with ESMTP id j14LdCmq008295 for ; Fri, 4 Feb 2005 16:39:25 -0500 (EST) Received: from [192.168.2.2] ([200.12.239.103]) by ms9.netsolmail.com (Mirapoint Messaging Server MOS 3.2.2-GA) with ESMTP id CNG85287; Fri, 4 Feb 2005 16:39:10 -0500 (EST) Subject: PG 8 Out of memory issuing queries From: Werner Bohl Reply-To: WernerBohl@infutor.com To: PgSQL ADMIN Content-Type: text/plain Organization: Infutor de Costa Rica S.A. Message-Id: <1107553146.16535.6.camel@sirio> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 04 Feb 2005 15:39:06 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/38 X-Sequence-Number: 16206 Hi! Hope anybody can help me with this issue. I have a fairly large table (~75 million rows) that where imported without pk. Tried to create a pk on a supposed unique field, but failed with duplicates. So i issued: select oldid from table group by oldid having count(*) > 1 and it fails with Out of memory. Tried to create a new pk using: alter table add newid serial primary key; and it also fails with out of memory error. Are there any settings on postgresql.conf that I may change to prevent this error? This is on Windows XP profesional with Postgresql 8.0 TIA, -- Werner Bohl Infutor de Costa Rica S.A.