Long running query in new production, not so long in old

Поиск
Список
Период
Сортировка
От Mark Steben
Тема Long running query in new production, not so long in old
Дата
Msg-id CADyzmyy9afP526per2wRO6PBn=uqZe6jtpsRLyiFE5CG4PoQiA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Long running query in new production, not so long in old
Re: Long running query in new production, not so long in old
Список pgsql-admin
Дерево обсуждения
Good evening

We are moving to a new VM environment (expedient) and have one query  that typically runs in 22 - 25 seconds in our old environment, but is running in about 1 hour, 20 minutes in our new.  I'd like some insight as to why the explain is showing shared buffer hits numbering over 113 milliion
in the new environment and only 445 thousand in the old.  I have sent the explains along with the table descriptions, row counts, the one function that I know causes the bottleneck,  the query, some relevant configuration settings in postgresql conf (identical in both environments)
and a listing from top in both environments, showing memory, shared memory, and cpu.

Everything seems to be identical or close, except for the shared buffer count in the explain.  
Any insight would be appreciated.

Thank you,


--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





Вложения

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

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: Unique Index Disk Consumption
Следующее
От: Alexander Shaburov
Дата:
Сообщение: Re: Long running query in new production, not so long in old