reindexing

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: reindexing
Date: 2011-02-08 00:12:20
Message-ID: AANLkTimQv3u9J56QO2ny_jEb8Lnwb4NJoDKXKSaq_1QA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Hunsaker 2011-02-08 00:23:38 Re: reindexing
Previous Message Jens Sauer 2011-02-07 23:16:34 Re: fulltext search and hunspell