Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D709A633066 for ; Thu, 12 Feb 2009 17:45:52 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68528-10 for ; Thu, 12 Feb 2009 17:45:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mk-filter-1-a-1.mail.uk.tiscali.com (mk-filter-1-a-1.mail.uk.tiscali.com [212.74.100.52]) by mail.postgresql.org (Postfix) with ESMTP id E0021633056 for ; Thu, 12 Feb 2009 17:45:32 -0400 (AST) X-Trace: 148573620/mk-filter-1.mail.uk.tiscali.com/B2C/$b2c-THROTTLED-DYNAMIC/b2c-CUSTOMER-DYNAMIC-IP/80.225.116.207/None/john.lister-ps@kickstone.com X-SBRS: None X-RemoteIP: 80.225.116.207 X-IP-MAIL-FROM: john.lister-ps@kickstone.com X-MUA: Thunderbird 2.0.0.19 (Windows/20081209) X-IP-BHB: Once X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AjsBALMmlElQ4XTP/2dsb2JhbAAI1DqEGAY X-IronPort-AV: E=Sophos;i="4.38,198,1233532800"; d="scan'208";a="148573620" Received: from ppp-3-207.bris-a-2.access.uk.tiscali.com (HELO [192.168.6.11]) ([80.225.116.207]) by smtp.tiscali.co.uk with ESMTP; 12 Feb 2009 21:45:30 +0000 Message-ID: <4994987F.1030204@kickstone.com> Date: Thu, 12 Feb 2009 21:45:35 +0000 From: John Lister User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: database corruption help References: <507152DDF8AB4DF093BD01A8BEC7C659@squarepi.com> <17205.1234200693@sss.pgh.pa.us> <4990840C.4090900@kickstone.com> <20151.1234208044@sss.pgh.pa.us> <49908D72.7040904@kickstone.com> <25753.1234224090@sss.pgh.pa.us> <4991338B.704@kickstone.com> <4994906B.6090408@kickstone.com> <17204.1234474784@sss.pgh.pa.us> In-Reply-To: <17204.1234474784@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/85 X-Sequence-Number: 31306 I'm running ubuntu and can see references to only one log file which i'm assuming is the postmaster log.. Anyway the only relevant bits are: GMT LOG: relation "pg_class" TID 15538/4: dead HOT-updated tuple --- cannot shrink relation 2009-02-12 21:06:40 GMT STATEMENT: VACUUM FULL VERBOSE ANALYZE pg_class 2009-02-12 21:06:40 GMT WARNING: index "pg_class_relname_nsp_index" contains 1818 row versions, but table contains 1813 row versions If that helps... Thanks > John Lister writes: > >> I seem to have more dead rows now.. >> doing a vacuum full on pg_class gives me >> > > >> INFO: vacuuming "pg_catalog.pg_class"INFO: "pg_class": found 37 >> removable, 1845 nonremovable row versions in 18905 pages >> DETAIL: 27 dead row versions cannot be removed yet. >> Nonremovable row versions range from 160 to 229 bytes long. >> There were 933834 unused item pointers. >> Total free space (including removable row versions) is 150368692 bytes. >> 18839 pages are or will become empty, including 0 at the end of the table. >> 0 pages containing 0 free bytes are potential move destinations. >> > > Hmm, that last seems to indicate that do_shrinking has been reset. > It looks like the cases where that happens are reported with elog(LOG) > which means they probably only went to the postmaster log (maybe we > should fix things so that vacuum verbose reports those). What have > you got in the postmaster log? > > regards, tom lane >