Skip site navigation (1) Skip section navigation (2)

Re: disabling an index without deleting it?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Peter Koczan <pjkoczan(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: disabling an index without deleting it?
Date: 2008-02-27 20:02:46
Message-ID: 6515.1204142566@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Jeff Davis <pgsql(at)j-davis(dot)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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-02-27 20:26:23
Subject: Re: Optimizing t1.col like '%t2.col%'
Previous:From: Dan KaplanDate: 2008-02-27 19:47:43
Subject: Optimizing t1.col like '%t2.col%'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group