Re: Ambigous Plan - Larger Table on Hash Side
| От | Jeff Janes |
|---|---|
| Тема | Re: Ambigous Plan - Larger Table on Hash Side |
| Дата | |
| Msg-id | CAMkU=1wNfDjpd07gBvziFN+CVsRdOz6Cpj0QrUacBrhfbi_QkQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Ambigous Plan - Larger Table on Hash Side (Narendra Pradeep U U <narendra.pradeep@zohocorp.com>) |
| Ответы |
Re: Ambigous Plan - Larger Table on Hash Side
|
| Список | pgsql-hackers |
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 по дате отправления: