| 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: | Whole Thread | Raw Message | 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 |