Re: Disabling an index temporarily - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Disabling an index temporarily
Date
Msg-id 20151214.122441.2235269626568468653.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Disabling an index temporarily  (Corey Huinker <corey.huinker@gmail.com>)
List pgsql-hackers
>> On Sun, Dec 13, 2015 at 1:16 AM, Jaime Casanova <
>> jaime.casanova@2ndquadrant.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 thisbecause 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



pgsql-hackers by date:

Previous
From: Bill Moran
Date:
Subject: Re: Disabling an index temporarily
Next
From: Tom Lane
Date:
Subject: Re: Disabling an index temporarily