Re: does this mean i have a corruption?

tech(at)leatherlink(dot)net wrote:
> On Mon June 5 2006 1:31 am, Adam Witney wrote:
>> Tom Lane wrote:
>>> Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
>>>> bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
>>>> bioassay_id = 5153 group by bioassay_id;
>>>> bioassay_id | count
>>>> -------------+-------
>>>> 5153 | 20000
>>>> 9712 | 120
>>> That's pretty interesting :-(. What PG version is this? Is there an
>>> index on bioassay_id, and if so is the query using it? REINDEXing
>>> the index might fix it.
>> aha yes... this is 7.4.12 by the way. I was confused as loading last
>> nights backup into a duplicate database made the problem go away. But as
>> you suggested running a REINDEX on the offending index fixed the problem!
>>
>
> That is interesting. What explains this behaviour? Should we be running
> REINDEX regularly?

I don't know, so posting your question to the list. I meant to ask last
night in fact, should i be worried as to why this occurred?

thanks

adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.