Re: Performance of a Query - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Performance of a Query
Date
Msg-id CAOR=d=1sArN+gw6AUZa9Znz13Hcz_kW4UuyMRG9nMcNzNvfXbw@mail.gmail.com
Whole thread Raw
In response to RE: Performance of a Query  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
List 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 by date:

Previous
From: "Kumar, Virendra"
Date:
Subject: RE: Performance of a Query
Next
From: Michael Paquier
Date:
Subject: Re: Need Help on wal_compression