Re: "slow" queries

Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us] wrote:
> Well, that's certainly a sufficient reason, if perhaps not the only
> reason. Dropping ts_defects_20090227 will require removal of FK triggers
> on ts_transets, and we can't do that concurrently with transactions that
> might be trying to fire those triggers.
>
> Now admittedly, it would probably be sufficient to take ExclusiveLock
> rather than AccessExclusiveLock when removing triggers, since we do not
> have triggers ON SELECT. Right now though, we just take
> AccessExclusiveLock for most any DDL on a table. There was a patch
> submitted last fall to reduce DDL locking in some cases, but it hasn't
> been reworked to fix the problems that were pointed out (and I
> disremember if it addressed DROP TRIGGER in particular anyway).
>
> regards, tom lane

Thanks for furthering my understanding of postgres (and probably other
SQL servers as well). I can fix this problem easily.

Brian