| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Oleg Golovanov <rentech(at)mail(dot)ru> |
| Subject: | Re: Parallel Hash take II |
| Date: | 2017-09-13 23:57:32 |
| Message-ID: | CAEepm=0VwBX84zaBj4Gvpx8xQfNO2en_MWa3g0PiGVAxe8VzQg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Sep 14, 2017 at 12:51 AM, Prabhat Sahu
<prabhat(dot)sahu(at)enterprisedb(dot)com> wrote:
> Setting with lower "shared_buffers" and "work_mem" as below, query getting crash but able to see explain plan.
Thanks Prabhat. A small thinko in the batch reset code means that it
sometimes thinks the shared skew hash table is present and tries to
probe it after batch 1. I have a fix for that and I will post a new
patch set just as soon as I have a good regression test figured out.
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-09-14 00:15:13 | Re: generated columns |
| Previous Message | Alexander Korotkov | 2017-09-13 23:48:42 | Re: [PATCH] Incremental sort |