Re: Re: Query > 1000× slowdown after adding datetime comparison

Поиск
Список
Период
Сортировка
От twoflower
Тема Re: Re: Query > 1000× slowdown after adding datetime comparison
Дата
Msg-id 1441053041230-5864101.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison  (Stefan Keller <sfkeller@gmail.com>)
Ответы Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison  (Stefan Keller <sfkeller@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
I did not. I wanted to compare this query to the one I tried before, having
*documenttype = 4* as the sole condition. That one was very fast and the
*documenttype* was not indexed either.

But this query, using the new temporary column, still runs, after 48
minutes...



--
View this message in context:
http://postgresql.nabble.com/Query-1-000-000-slowdown-after-adding-datetime-comparison-tp5864045p5864101.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

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

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison