Search Postgresql Archives

Re: does this mean i have a corruption?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux