reindexing - Mailing list pgsql-general

From akp geek
Subject reindexing
Date
Msg-id AANLkTimQv3u9J56QO2ny_jEb8Lnwb4NJoDKXKSaq_1QA@mail.gmail.com
Whole thread Raw
Responses Re: reindexing
List pgsql-general
Hi all -

        I ran query this morning, I got a wrong results. I have run the same query in an other environment with same data and I got the result set I was expecting.

       After that I did a re index and on the table I was getting incorrect results, the data then came out fine,

        Do I have to reindex periodically to make sure the data retrieval would be correct?

Thanks for you help

Regards

pgsql-general by date:

Previous
From: Jens Sauer
Date:
Subject: Re: fulltext search and hunspell
Next
From: Alex Hunsaker
Date:
Subject: Re: reindexing