On 30/04/13 14:49, Igor Neyman wrote: > >> -----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 > Thanks a lot.
-- 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
