Hi, On Tue, 2012-09-25 at 20:42 -0400, Robert Haas wrote:
> It seems therefore that REINDEX + VACUUM with > vacuum_freeze_table_age=0 is not quite sufficient to recover from this > problem. If your index has come to contain a circularity, vacuum will > fail to terminate, and you'll need to drop it completely to recover. What is the difference between REINDEX and dropping and recreating index? (or say, creating the same index with another name, dropping old one, and renaming the new one with old one?) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
signature.asc
Description: This is a digitally signed message part
