Postgres Pro
Downloads
Home   >   mailing lists

Disable an index temporarily - Mailing list pgsql-general

From Torsten Förtsch
Subject Disable an index temporarily
Date
Msg-id 5352E1BC.9080000@gmx.net
Whole thread Raw
Responses Re: Disable an index temporarily  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Disable an index temporarily  (Rajeev rastogi <rajeev.rastogi@huawei.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Marc Mamin
Date:
Subject: Re: Could use some advice on search architecture
Next
From: Robin
Date:
Subject: Re: Could use some advice on search architecture