Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 867C2B5DBF9 for ; Wed, 25 May 2011 14:41:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 56531-07 for ; Wed, 25 May 2011 17:41:17 +0000 (UTC) X-Greylist: delayed 00:28:35.83499 by SQLgrey-1.7.6 Received: from mailhub1.renesys.com (mailhub1.ep.renesys.com [195.160.236.248]) by mail.postgresql.org (Postfix) with ESMTP id 16DE1B5DC1D for ; Wed, 25 May 2011 14:41:16 -0300 (ADT) Received: from ops05.psm1.renesys.com (ops05.psm1.renesys.com [10.200.1.25]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mailhub1.renesys.com (Postfix) with ESMTP id 42F68671A4 for ; Wed, 25 May 2011 17:12:40 +0000 (UTC) Received: (from rouilj@localhost) by ops05.psm1.renesys.com (8.13.8/8.13.8/Submit) id p4PHCdCH026102 for pgsql-performance@postgresql.org; Wed, 25 May 2011 17:12:39 GMT Date: Wed, 25 May 2011 17:12:39 +0000 From: John Rouillard To: pgsql-performance@postgresql.org Subject: Re: "error with invalid page header" while vacuuming pgbench data Message-ID: <20110525171239.GC31823@renesys.com> References: <20110523221603.GA31823@renesys.com> <4DDA9780020000250003DB62@gw.wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4DDA9780020000250003DB62@gw.wicourts.gov> User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.01 tagged_above=-10 required=5 tests=T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/339 X-Sequence-Number: 43848 On Mon, May 23, 2011 at 05:21:04PM -0500, Kevin Grittner wrote: > John Rouillard wrote: > > > I seem to be able to provoke this error: > > > > vacuum...ERROR: invalid page header in > > block 2128910 of relation base/16385/21476 > > What version of PostgreSQL? Hmm, I thought I replied to this, but I haven't seen it come back to me on list. It's postgres version: 8.4.5. rpm -q shows postgresql84-server-8.4.5-1.el5_5.1 -- -- rouilj John Rouillard System Administrator Renesys Corporation 603-244-9084 (cell) 603-643-9300 x 111