Re: "slow" queries

Список
Период
Сортировка
От Tom Lane
Тема Re: "slow" queries
Дата
Msg-id 22227.1236022171@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "slow" queries  (Brian Cox)
Ответы Re: "slow" queries  (Tim Bunce)
Список pgsql-performance
Дерево обсуждения
"slow" queries  (Brian Cox, )
 Re: "slow" queries  (Robert Haas, )
 Re: "slow" queries  (Tom Lane, )
 Re: "slow" queries  ("Cox, Brian", )
  Re: "slow" queries  (Tom Lane, )
 Re: "slow" queries  (Brian Cox, )
  Re: "slow" queries  (Scott Carey, )
  Re: "slow" queries  (Robert Haas, )
  Re: "slow" queries  (Tom Lane, )
   Re: "slow" queries  (Tim Bunce, )
    Re: "slow" queries  (Scott Marlowe, )
 Re: "slow" queries  (Brian Cox, )
  Re: "slow" queries  (Tom Lane, )
 Re: "slow" queries  (Brian Cox, )
Brian Cox <> writes:
> select locktype,database,relation,virtualxid,virtualtransaction,pid,mode
> from pg_locks order by mode;

If you hadn't left out the "granted" column we could be more sure,
but what it looks like to me is the DROP (pid 13842) is stuck behind
the <IDLE> transaction (pid 13833).  In particular these two rows of
pg_locks look like a possible conflict:

>   relation      | 26472437 | 26472508 |            | 15/69749
> | 13842 | AccessExclusiveLock

>   relation      | 26472437 | 26472508 |            | 11/131
> | 13833 | AccessShareLock

            regards, tom lane

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

Предыдущее
От: Aaron Guyon
Дата:
Сообщение: Postgres 8.3, four times slower queries?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres 8.3, four times slower queries?