Postgres Pro
Downloads
Home   >   mailing lists

Re: Ambigous Plan - Larger Table on Hash Side - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Ambigous Plan - Larger Table on Hash Side
Date
Msg-id CAMkU=1wNfDjpd07gBvziFN+CVsRdOz6Cpj0QrUacBrhfbi_QkQ@mail.gmail.com
Whole thread Raw
In response to Re: Ambigous Plan - Larger Table on Hash Side  (Narendra Pradeep U U <narendra.pradeep@zohocorp.com>)
Responses Re: Ambigous Plan - Larger Table on Hash Side  (Narendra Pradeep U U <narendra.pradeep@zohocorp.com>)
List pgsql-hackers
Tree view
On Tue, Mar 13, 2018 at 4:02 AM, Narendra Pradeep U U <narendra.pradeep@zohocorp.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

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: PATCH: Configurable file mode mask
Next
From: Alvaro Herrera
Date:
Subject: Re: User defined data types in Logical Replication