Disable an index temporarily

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Disable an index temporarily
Date: 2014-04-19 20:51:08
Message-ID: 5352E1BC.9080000@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

an index can be INVALID (pg_index.indisvalid=false).

I want to temporarily disable an index so that it won't be used to
access data but will still be updated.

Can I simply set pg_index.indisvalid=false and later turn it true again?

Thanks,
Torsten

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robin 2014-04-19 22:58:08 Re: Could use some advice on search architecture
Previous Message Marc Mamin 2014-04-19 17:36:18 Re: Could use some advice on search architecture