| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Jesse Zhang <sbjesse(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, david(dot)g(dot)kimura(at)gmail(dot)com, soumyadeep2007(at)gmail(dot)com |
| Subject: | Re: Avoiding hash join batch explosions with extreme skew and weird stats |
| Date: | 2020-09-24 03:39:46 |
| Message-ID: | 20200924033946.GD28585@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Aug 31, 2020 at 03:13:06PM -0700, Melanie Plageman wrote:
> Attached is the current version of adaptive hash join with two
> significant changes as compared to v10:
The CF bot is complaining about a regression test failure:
@@ -2465,7 +2465,7 @@
Gather (actual rows=469 loops=1)
Workers Planned: 1
Workers Launched: 1
- -> Parallel Hash Left Join (actual rows=234 loops=2)
+ -> Parallel Hash Left Join (actual rows=235 loops=2)
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-09-24 03:44:01 | Re: "cert" + clientcert=verify-ca in pg_hba.conf? |
| Previous Message | Michael Paquier | 2020-09-24 03:34:07 | Re: BUG #15383: Join Filter cost estimation problem in 10.5 |