| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Narendra Pradeep U U <narendra(dot)pradeep(at)zohocorp(dot)com> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Ambigous Plan - Larger Table on Hash Side |
| Date: | 2018-03-14 19:10:27 |
| Message-ID: | CAMkU=1wNfDjpd07gBvziFN+CVsRdOz6Cpj0QrUacBrhfbi_QkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Mar 13, 2018 at 4:02 AM, Narendra Pradeep U U <
narendra(dot)pradeep(at)zohocorp(dot)com> wrote:
> Hi,
> Thanks everyone for your suggestions. I would like to add explain
> analyze of both the plans so that we can have broader picture.
>
> I have a work_mem of 1000 MB.
>
Is it possible to repeat with 2000MB or 3000MB? It would be interesting to
see what the estimated cost and what the actual time would be if there were
only 1 batch rather than 2.
Also, can you repeat all of these with EXPLAIN (ANALYZE, TIMING OFF) ?
Sometimes the act of measuring the times can distort the times by quite a
bit. (It will still give an overall execution time, it just won't try to
attribute that time to the individual steps)
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-03-14 19:15:52 | Re: User defined data types in Logical Replication |
| Previous Message | David Steele | 2018-03-14 18:15:03 | Re: PATCH: Configurable file mode mask |