DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=Ok1cpGJ8L31UgXUcuZQsU+bEolM5Hv87sa1qgsTFF7IqwCmYy9JdoTiHcrFfXirhiVmfa7bLCXfClPhodBb3YrJJdBJ+8C8HEvPaf88mf7WakOhFoz19P1SroMX/qMhqohkXfTXhLLAVdealh+AHpg440chHUJzwDptdnzVRRW8=;
References: 
 <CALyjCLs0iswbroQtucQWeL+CcGGac0t8iq1yx1Sa8Xti=O3yeg@mail.gmail.com>
	<A737B7A37273E048B164557ADEF4A58B0580491C@ntex2010a.host.magwien.gv.at>
	<CALyjCLuq1HHH9vFSW9M9zp010T_6hggYQeaZNdnHU-yasF2Kmg@mail.gmail.com>
Message-ID: <1367322683.44994.YahooMailNeo@web162902.mail.bf1.yahoo.com>
Date: Tue, 30 Apr 2013 04:51:23 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: PANIC during VACUUM
To: German Becker <german.becker@gmail.com>,
	Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CALyjCLuq1HHH9vFSW9M9zp010T_6hggYQeaZNdnHU-yasF2Kmg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

[please don't top-post]

German Becker <german.becker@gmail.com> wrote:
> Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
>> German Becker wrote:

>>> I am testing version 9.1.9 before putting it in production. One
>>> of my tests involved deleting a the contents of a big table ( ~
>>> 13 GB size) and then VACUUMing it. During VACUUM PANICS.

>> If you mess with the database files, errors like this are to be
>> expected.

> Thanks for your reply. In which sense did I mess with the
> database files?

You didn't say how you deleted the contents of that big table, and
it appears that Albe assumed you deleted or truncated the
underlying disk file rather than using the DELETE or TRUNCATE SQL
statement.

In any event, more details would help people come up with ideas on
what might be wrong.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin