Re: Disabling an index temporarily

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: julien(dot)rouhaud(at)dalibo(dot)com
Cc: laurenz(dot)albe(at)wien(dot)gv(dot)at, jd(at)commandprompt(dot)com, pgsql-hackers(at)postgreSQL(dot)org, teodor(at)sigaev(dot)ru
Subject: Re: Disabling an index temporarily
Date: 2015-12-12 15:22:11
Message-ID: 20151213.002211.301956913624378834.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Oleg and Teodor announced some time ago an extension for this exact use
> case, see
> http://www.postgresql.org/message-id/Pine.LNX.4.64.0910062354510.6801@sn.sai.msu.ru
>
> This also has the advantage of not needing an exclusive lock on the index.

Thanks for the info. I will try out them.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-12-12 17:02:13 Re: Rework the way multixact truncations work
Previous Message Andres Freund 2015-12-12 13:31:30 Re: Error with index on unlogged table