Jeff Davis <pgsql(at)j-davis(dot)com> writes:
>>> drop index abc_dx;
>>> select ....
> 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 Lane||Date: 2008-02-27 20:26:23|
|Subject: Re: Optimizing t1.col like '%t2.col%' |
|Previous:||From: Dan Kaplan||Date: 2008-02-27 19:47:43|
|Subject: Optimizing t1.col like '%t2.col%'|