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
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 |