vacuum failure...

From: "Michael Richards" <michael(at)fastmail(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: vacuum failure...
Date: 2003-02-11 15:01:24
Message-ID: 3E491044.000001.72557@ns.interchange.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I've got a problem vacuuming a table and can't seem to find a way to
fix it...

vacuum full verbose analyze folders;
NOTICE: --Relation folders--
NOTICE: Pages 18598: Changed 0, reaped 18598, Empty 0, New 0; Tup
69849: Vac 0, Keep/VTL 0/0, UnUsed 1870572, MinLen 64, MaxLen 88; Re-
using: Free/Avail. Space 139159408/139159408; EndEmpty/Avail. Pages
0/18598.
CPU 0.34s/0.09u sec elapsed 0.51 sec.
ERROR: No one parent tuple was found

-Michael
_________________________________________________________________
http://fastmail.ca/ - Fast Secure Web Email for Canadians
>From pgsql-sql-owner(at)postgresql(dot)org Tue Feb 11 10:34:16 2003
X-Original-To: pgsql-sql(at)postgresql(dot)org
Received: from localhost (postgresql.org [64.49.215.8])
by postgresql.org (Postfix) with ESMTP id B8543475AAC
for <pgsql-sql(at)postgresql(dot)org>; Tue, 11 Feb 2003 10:34:15 -0500 (EST)
Received: from trill.maridan.net (unknown [217.6.52.210])
by postgresql.org (Postfix) with ESMTP id 4148F475A9E
for <pgsql-sql(at)postgresql(dot)org>; Tue, 11 Feb 2003 10:34:13 -0500 (EST)
Received: from polonium.de ([212.121.156.162])
by trill.maridan.net (8.9.3/8.9.3) with ESMTP id QAA24667
for <pgsql-sql(at)postgresql(dot)org>; Tue, 11 Feb 2003 16:34:12 +0100
Message-ID: <3E491854(dot)9080401(at)polonium(dot)de>
Date: Tue, 11 Feb 2003 16:35:48 +0100
From: Rafal Kedziorski <rafcio(at)polonium(dot)de>
Organization: POLONIUM
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql(at)postgresql(dot)org
Subject: constrains questios ..
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/214
X-Sequence-Number: 11612

Hi,

is better to create constrains while creating table or after the table
is created? I'm working on sql script which should create about 40 tables.

Best Regards,
Rafal

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-02-11 15:43:10 Re: vacuum failure...
Previous Message Héctor Iturre 2003-02-11 13:29:31 Problems with Transactions