Re: Odd blocking (or massively latent) issue - even with EXPLAIN

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Дата
Msg-id 500DEC9E.90603@ringerc.id.au
обсуждение исходный текст
Ответ на Re: Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
Ответы Re: Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
Список pgsql-performance
Дерево обсуждения 
On 07/23/2012 10:46 PM, Jim Vanns wrote:
> Nothing obvious - and we log a fair amount. No tmp table creations,
> no locks held.
>
> To add to this EXPLAIN reports it took only 0.23ms to run (for example)
> whereas the wall clock time is more like 20-30 minutes (or up to n hours
> as I said where everything appears to click back into place at the same
> time).
How many concurrent connections do you have?

--
Craig Ringer

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

Предыдущее
От: Kenneth Tilton
Дата:
Сообщение: Re: Efficiency of EXISTS?
Следующее
От: "Martin French"
Дата:
Сообщение: Re: Odd blocking (or massively latent) issue - even with EXPLAIN