X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1850D9FB386 for ; Wed, 2 Aug 2006 01:37:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96349-03 for ; Wed, 2 Aug 2006 01:37:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id E31CB9FB379 for ; Wed, 2 Aug 2006 01:37:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k724blbq009131; Wed, 2 Aug 2006 00:37:47 -0400 (EDT) To: adey cc: "pgsql-admin@postgresql.org" , "PostgreSQL Admin" , postgresql-l Subject: Re: What's using all my RAM? In-reply-to: <1c66bda80608012109x125180eeh38674c853ea50434@mail.gmail.com> References: <1c66bda80608012109x125180eeh38674c853ea50434@mail.gmail.com> Comments: In-reply-to adey message dated "Wed, 02 Aug 2006 16:09:43 +1200" Date: Wed, 02 Aug 2006 00:37:47 -0400 Message-ID: <9130.1154493467@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.177 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/20 X-Sequence-Number: 22564 adey writes: > Please could someone tell me how to discover what is using all of my RAM? > I am trying to run a vacuum against Postgres, but it fails immediately > with:- > "ERROR: out of memory > DETAIL: Failed on request of size 1073741820." I'd bet lunch that this is a corrupt-data problem, not an out-of-memory problem --- specifically, a bad value in a field length word. See the archives for many prior examples. > Postgres v7.4.2 (upgrade underway) Yipes :-( regards, tom lane