Re: Windows query weird result

On 30/04/13 14:49, Igor Neyman wrote:
>
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>> owner(at)postgresql(dot)org] On Behalf Of Igor Neyman
>> Sent: Tuesday, April 30, 2013 9:30 AM
>> To: Lutz Fischer; pgsql-general(at)postgresql(dot)org
>> Cc: Aaron Abreu
>> Subject: Re: [GENERAL] Windows query weird result
>>
>>> Seems like REINDEX INDEX rescored; did the trick.
>>> Any idea how to find out whether a index is corrupted?
>>>
>>> --
>>> Lutz Fischer
>>> lfischer(at)staffmail(dot)ed(dot)ac(dot)uk
>>> +44 131 6517057
>>>
>>>
>>> The University of Edinburgh is a charitable body, registered in
>>> Scotland, with registration number SC005336.
>> The only way I know is to execute SELECT on the table that will cause
>> full index scan.
>>
>> Regards,
>> Igor Neyman
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To
>> make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
> As a side not, one more thing.
> Since you mentioned that corruption happened in Windows environment,
> I'd suggest that Postgres data directory should be excluded from being scanned by whatever anti-virus software you have running on that system (I suspect there is one). Scanning PG data directory by anti-virus software could reduce performance and also in "severe" cases - corruption.
>
> Regards,
> Igor Neyman
>
Thanks a lot.

--
Lutz Fischer
lfischer(at)staffmail(dot)ed(dot)ac(dot)uk
+44 131 6517057

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.