Re: Windows query weird result

> -----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