> > > > Seems like REINDEX INDEX rescored; did the trick. > Any idea how to find out whether a index is corrupted? > > -- > Lutz Fischer > [email protected] > +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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
