Re: One query run twice in parallel results in huge performance decrease

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: One query run twice in parallel results in huge performance decrease
Дата
Msg-id CAMkU=1wyY0BCkae12-kn=hAg81TJi2Yz+9WHvPfruzzUvxbazg@mail.gmail.com
обсуждение исходный текст
Ответ на One query run twice in parallel results in huge performance decrease  (Jan Michel <Jan@mueschelsoft.de>)
Ответы Re: One query run twice in parallel results in huge performance decrease
Список pgsql-performance
Дерево обсуждения
On Fri, Nov 29, 2013 at 2:07 PM, Jan Michel <Jan@mueschelsoft.de> wrote:

When I run a second instance of this query in a unrelated database on the
same server, they take 100% CPU, no iowait and they do not finish even
after more than a day.

The planner is not aware of what else is going on in the server, so it can't change plans with that in mind.  So I think that that is a red herring.  I'd guess that the 2nd database is missing the geometry index, or has it defined in some different way such that the database doesn't think it can be used.

Are you sure that you get good plans when you run the exact same queries on the exact same database/schema one at a time?

Cheers,

Jeff

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

Предыдущее
От: Jan Michel
Дата:
Сообщение: One query run twice in parallel results in huge performance decrease
Следующее
От: Jan Michel
Дата:
Сообщение: Re: One query run twice in parallel results in huge performance decrease