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! thanks very much for your help Tom adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
