> -----Original Message----- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Igor Neyman > Sent: Tuesday, April 30, 2013 9:30 AM > To: Lutz Fischer; pgsql-general@postgresql.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 > > 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
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general