Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

From: Denis Braekhus <denis(at)startsiden(dot)no>
To: Lonni Friedman <netllama(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT
Date: 2004-05-08 15:29:38
Message-ID: 409CFCE2.6070207@startsiden.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Lonni Friedman wrote:

| Thanks for your reply. I thought (perhaps erroneously) that there
| wasn't any real difference between dropping an index then recreating
| it, and just reindexing an index?

I am definitely not sure, and I agree it sounds logical that they would
produce the same results. However my experience was that dropping and
re-creating the index worked.

The docs say :
"Another approach to dealing with a corrupted user-table index is just
to drop and recreate it. This may in fact be preferable if you would
like to maintain some semblance of normal operation on the table
meanwhile. REINDEX acquires exclusive lock on the table, while CREATE
INDEX only locks out writes not reads of the table."

Indicating that they should produce the same results, but that they work
differently. I am not sure what that implies, but maybe someone else knows ?

Regards
- --
Denis
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-nr2 (Windows XP)

iD8DBQFAnPzivsCA6eRGOOARAl1OAKC0zcgN409n7ylgyHV61J9/o4LsBgCgqEpJ
yT24Y03fQItzhbRlxHyUg8s=
=YBoz
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Vlasenko 2004-05-08 16:16:08 unsubscride pqsql-general
Previous Message Tom Lane 2004-05-08 00:37:26 Re: Interpreting vacuum verbosity