| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | corey(dot)huinker(at)gmail(dot)com |
| Cc: | obartunov(at)gmail(dot)com, jaime(dot)casanova(at)2ndquadrant(dot)com, jd(at)commandprompt(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Disabling an index temporarily |
| Date: | 2015-12-14 03:24:41 |
| Message-ID: | 20151214.122441.2235269626568468653.t-ishii@sraoss.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>> On Sun, Dec 13, 2015 at 1:16 AM, Jaime Casanova <
>> jaime(dot)casanova(at)2ndquadrant(dot)com> wrote:
>>
>>> indexrelid = 'indexname'::regclass;
>>
>>
>> This works, but might bloat system catalog.
>>
>>
> +1 for the functionality.
> +1 for ALTER INDEX foo SET DISABLED
-1 for the reason I mentioned in the up thread. Also I dislike this
because this does not work with standby servers.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-12-14 03:27:31 | Re: Disabling an index temporarily |
| Previous Message | Bill Moran | 2015-12-14 03:23:56 | Re: Disabling an index temporarily |