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_domai
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=# vac