[PERFORM] query performance issue

Поиск
Список
Период
Сортировка
От Samir Magar
Тема [PERFORM] query performance issue
Дата
Msg-id CAA=to3gXpr94TqSAYXT9zwxYwY_xKrLFnu8ZJNgJKP-kWza2CA@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PERFORM] query performance issue
Re: [PERFORM] query performance issue
Список pgsql-performance
Дерево обсуждения
Hello,
I am having performance issues with one of the query.
The query is taking 39 min to fetch 3.5 mil records.

I want to reduce that time to 15 mins. 
could you please suggest something to its performance?

server configuration:
 CPUs = 4
memory = 16 GM
shared_buffers = 3 GB
work_mem = 100MB
effective_cache_size = 12 GB

we are doing the vacuum/analyze regularly on the database. 

attached is the query with its explain plan.

Thanks,
Samir Magar  
Вложения

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

Предыдущее
От: legrand legrand
Дата:
Сообщение: [PERFORM] Re: Query planner gaining the ability to replanning after start ofquery execution.
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] query performance issue