Re: Creating indeces on existing tables... - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: Creating indeces on existing tables...
Date
Msg-id 3A789C6E.F1DB34F2@tpf.co.jp
Whole thread Raw
In response to Creating indeces on existing tables...  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general
Steve Wolfe wrote:
>
>   OK, one of my tables was getting duplicate entries, and I thought I'd
> create a unique index on a particular field.  So, I created the index:
>
> domains=# create unique index idx_domain_name on domain (domain_name);
> CREATE
>
> Then, tried a vaccum:
>
> domains=# vacuum analyze;
> NOTICE:  Index idx_domain_name: NUMBER OF INDEX' TUPLES (305) IS NOT THE
> SAME AS HEAP' (311).
>         Recreate the index.
> VACUUM
>

This is a known bug.
Probably there's a long transaction somewhere.
It is fixed in 7.1.

Regards,
Hiroshi Inoue

pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: Re: Re: grant privileges to a database
Next
From: "Oliver Elphick"
Date:
Subject: Re: trying to back up a database