Re: Performance of a Query

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Performance of a Query
Дата
Msg-id CAOR=d=1sArN+gw6AUZa9Znz13Hcz_kW4UuyMRG9nMcNzNvfXbw@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Performance of a Query  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
Список pgsql-performance
On Tue, Jan 9, 2018 at 4:09 PM, Kumar, Virendra
<Virendra.Kumar@guycarp.com> wrote:
> It did not seem to help.
> See attachment.

Yeah while it's still writing, it's about half as much but most of the
time seems to be in merging  etc multiple data sets. I'm wondering
what non-default values you might have set otherwise. Are you running
on SSDs? If so lowering random_page_cost might help, but again, this
might just be a very expensive query as well.


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

Предыдущее
От: "Kumar, Virendra"
Дата:
Сообщение: RE: Performance of a Query
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Need Help on wal_compression