Scott Marlowe wrote:
> On Tue, Jan 9, 2018 at 2:18 PM, Kumar, Virendra
> wrote:
> > Hello Gurus,
> >
> > I am struggling to tune a query which is doing join on top of aggregate for
> > around 3 million rows. The plan and SQL is attached to the email.
> >
> > Below is system Details:
> >
> > PGS
eem to help.
See attachment.
Regards,
Virendra
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Tuesday, January 09, 2018 6:00 PM
To: Kumar, Virendra
Cc: pgsql-performa...@postgresql.org
Subject: Re: Performance of a Query
On Tue, Jan 9, 2018 at 3:25 PM, Kumar,
On Tue, Jan 9, 2018 at 4:09 PM, Kumar, Virendra
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 y
It did not seem to help.
See attachment.
Regards,
Virendra
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Tuesday, January 09, 2018 6:00 PM
To: Kumar, Virendra
Cc: pgsql-performa...@postgresql.org
Subject: Re: Performance of a Query
On Tue, Jan 9, 2018 at
ilto:scott.marl...@gmail.com]
> Sent: Tuesday, January 09, 2018 5:08 PM
> To: Kumar, Virendra
> Cc: pgsql-performa...@postgresql.org
> Subject: Re: Performance of a Query
Try it with something reasonable like 64MB and then post your query
plans to explain.depesz and then here and le
: Tuesday, January 09, 2018 5:08 PM
To: Kumar, Virendra
Cc: pgsql-performa...@postgresql.org
Subject: Re: Performance of a Query
On Tue, Jan 9, 2018 at 2:18 PM, Kumar, Virendra
wrote:
> Hello Gurus,
>
> I am struggling to tune a query which is doing join on top of
> aggregate for arou
On Tue, Jan 9, 2018 at 2:18 PM, Kumar, Virendra
wrote:
> Hello Gurus,
>
> I am struggling to tune a query which is doing join on top of aggregate for
> around 3 million rows. The plan and SQL is attached to the email.
>
> Below is system Details:
>
> PGSQL version – 10.1
>
> OS – RHEL 3.10.0-693.5