From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org, Marko Tiikkaja <pgmail(at)joh(dot)to>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
Subject: | Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. |
Date: | 2012-09-26 06:46:32 |
Message-ID: | 1348641992.3516.45.camel@lenovo01-laptop03.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2012-09-26 08:45:56 | Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. |
Previous Message | Виктор Егоров | 2012-09-26 06:12:37 | Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. |
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Farina | 2012-09-26 07:08:29 | Re: system_information.triggers & truncate triggers |
Previous Message | Виктор Егоров | 2012-09-26 06:12:37 | Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. |