From: Palle Girgensohn <girgen@partitur.se>
To: pgsql-sql@postgresql.org
Subject: pg_attribute_relid_attnam_index problem after log disk filled up
Date: Mon, 28 Aug 2000 17:56:51 +0200
Message-ID: <39AA8BC3.3047D8CF@partitur.se> (raw)
Hi!
What's this? What to do? Shall I bother?
pp=> vacuum;
NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF
INDEX' TUPLES (3094) IS NOT THE SAME AS HEAP' (3093)
The database is rather large, and the time to run vacuum is too
short, so it feels like something is stopping the vacuum too
early. The problem started when the log partition (where
postmaster logging output is written) was full, and some
backends crashed. This is fixed, but it seems that postgres is
not fully recovered.
PostgreSQL 6.5.2 on i386-unknown-freebsd3.3, compiled by cc
Running on FreeBSD 3.5-RELEASE (SMP kernel).
Cheers,
Palle
--
Partitur Informationsteknik AB
Wenner-Gren Center +46 8 566 280 02
113 46 Stockholm +46 70 785 86 02
Sweden girgen@partitur.se
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: girgen@partitur.se
Subject: Re: pg_attribute_relid_attnam_index problem after log disk filled up
In-Reply-To: <39AA8BC3.3047D8CF@partitur.se>
References: <39AA8BC3.3047D8CF@partitur.se>
* 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