| From: | "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Performance of a Query |
| Date: | 2018-01-09 21:18:02 |
| Message-ID: | 7b438042521b45f89e510c20a798d22b@USFKL11XG20CN01.mercer.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.2.el7.x86_64
Binary - Dowloaded from postgres.org compiled and installed.
Hardware - Virtual Machine with 8vCPU and 32GB of RAM, on XFS filesystem.
Please let me know if you need more information.
Regards,
Virendra
________________________________
This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.
| Attachment | Content-Type | Size |
|---|---|---|
| AggQuery_Plan.txt | text/plain | 3.9 KB |
| AggQuery.sql | application/octet-stream | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reddygari, Pavan | 2018-01-09 21:32:33 | View preformance oracle to postgresql |
| Previous Message | Scott Marlowe | 2018-01-09 20:39:33 | Re: Need Help on wal_compression |