Vacuum and index - Mailing list pgsql-admin

From Jean-Marc Pigeon
Subject Vacuum and index
Date
Msg-id 200011100305.eAA35lT16490@new-york.safe.ca
Whole thread Raw
List pgsql-admin
Bonjour,


    Loading data (around 112000 record) to a newly created
    data-base, I am able to do select such as:

    select * from userreg where userid='cynthiaU';

    Where 'userid' is defined as:
    userid VARCHAR(30) UNIQUE,
    in the table.

    Everything work fine, as soon I run vacuum
    on this data-base some of the records "disappear",
    (say 10%) such the previous select is not responding, while

    select * from userreg where userid~*'cynthiaU';

    is still responding.
    Obviously there is an index problem, If drop and
    create the index related to the table, everything
    comeback fine....

    Questions:
    1) Why index become mis-aligned after a data-base
       vacuum?
    2) Is there a way to keep table and index aligned under
       vacuum?



A bientot
==========================================================================
Jean-Marc Pigeon              Internet:   Jean-Marc.Pigeon@safe.ca
SAFE Inc.                Phone: (514) 493-4280  Fax: (514) 493-1946
       REGULUS,  a real time accounting/billing package for ISP
           REGULUS' Home base <"http://www.regulus.safe.ca">
==========================================================================

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Implementing mod_perl, Perl 5.004, and Postgres
Next
From: Dronamraju Rajesh
Date:
Subject: Re: Implementing mod_perl, Perl 5.004, and Postgres