Re: disabling an index without deleting it? - Mailing list pgsql-performance

From Tom Lane
Subject Re: disabling an index without deleting it?
Date
Msg-id 6515.1204142566@sss.pgh.pa.us
Whole thread Raw
In response to Re: disabling an index without deleting it?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-performance
Jeff Davis <pgsql@j-davis.com> writes:
>>> begin;
>>> drop index abc_dx;
>>> select ....
>>> rollback;

> It may cause catalog bloat though, right?

Not in this particular case; AFAIR this will only result in catalog row
deletions, not updates.  So when the deletions roll back, there's no
dead rows to clean up.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Dan Kaplan"
Date:
Subject: t1.col like '%t2.col%'
Next
From: Tom Lane
Date:
Subject: Re: Optimizing t1.col like '%t2.col%'