Re: Windows query weird result

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Lutz Fischer <lfischer(at)staffmail(dot)ed(dot)ac(dot)uk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: Aaron Abreu <abreual(at)bay(dot)k12(dot)fl(dot)us>
Subject: Re: Windows query weird result
Date: 2013-04-30 13:30:03
Message-ID: A76B25F2823E954C9E45E32FA49D70EC13C6FFAC@mail.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ramiro Arraya 2013-04-30 13:31:46 Is it possible for Postgresql to interact with Transaction Manager (TM like Tuxedo) as a Ressource Manager (RM) ?
Previous Message Lutz Fischer 2013-04-30 12:34:01 Re: Windows query weird result