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