From: Michael Richards <michael@fastmail.ca>
To: pgsql-sql@postgresql.org
Subject: vacuum failure...
Date: Tue, 11 Feb 2003 10:01:24 -0500 (EST)
Message-ID: <3E491044.000001.72557@ns.interchange.ca> (raw)
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@postgresql.org Tue Feb 11 10:34:16 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
by postgresql.org (Postfix) with ESMTP id B8543475AAC
for <pgsql-sql@postgresql.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@postgresql.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@postgresql.org>; Tue, 11 Feb 2003 16:34:12 +0100
Message-ID: <3E491854.9080401@polonium.de>
Date: Tue, 11 Feb 2003 16:35:48 +0100
From: Rafal Kedziorski <rafcio@polonium.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@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: michael@fastmail.ca
Subject: Re: vacuum failure...
In-Reply-To: <3E491044.000001.72557@ns.interchange.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox