Re: Windows query weird result - Mailing list pgsql-general

From Igor Neyman
Subject Re: Windows query weird result
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC13C6FFAC@mail.corp.perceptron.com
Whole thread Raw
In response to Re: Windows query weird result  (Lutz Fischer <lfischer@staffmail.ed.ac.uk>)
Responses Re: Windows query weird result
List pgsql-general
> >
>
> Seems like REINDEX INDEX rescored; did the trick.
> Any idea how to find out whether a index is corrupted?
>
> --
> Lutz Fischer
> lfischer@staffmail.ed.ac.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


pgsql-general by date:

Previous
From: Lutz Fischer
Date:
Subject: Re: Windows query weird result
Next
From: Igor Neyman
Date:
Subject: Re: Windows query weird result