[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Creating indeces on existing tables...
From:       Hiroshi Inoue <Inoue () tpf ! co ! jp>
Date:       2001-01-31 23:14:54
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]