tech@xxxxxxxxxxxxxxx wrote: > On Mon June 5 2006 1:31 am, Adam Witney wrote: >> Tom Lane wrote: >>> Adam Witney <awitney@xxxxxxxxxx> 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.
