Re: "slow" queries

Поиск
Список
Период
Сортировка
От Brian Cox
Тема Re: "slow" queries
Дата
Msg-id 49AC4351.8050307@ca.com
обсуждение исходный текст
Ответ на "slow" queries  (Brian Cox <brian.cox@ca.com>)
Список pgsql-performance
Tom Lane [tgl@sss.pgh.pa.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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "slow" queries
Следующее
От: Tim Bunce
Дата:
Сообщение: Re: "slow" queries