| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie>, Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Tomas Vondra <tv(at)fuzzy(dot)cz>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: hashagg slowdown due to spill changes |
| Date: | 2020-07-26 23:17:38 |
| Message-ID: | 9d786d5d77c404834c033c0710f4f6d0c7702bb1.camel@j-davis.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 2020-07-25 at 15:08 -0700, Peter Geoghegan wrote:
> I find that Andres original "SELECT cat, count(*) FROM
> fewgroups_many_rows GROUP BY 1;" test case is noticeably improved by
> the patch. Without the patch, v13 takes ~11.46 seconds. With the
> patch, it takes only ~10.64 seconds.
I saw less of an improvement than you or Andres (perhaps just more
noise). But given that both you and Andres are reporting a measurable
improvement, then I went ahead and committed it. Thank you.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dilip Kumar | 2020-07-27 01:13:00 | Re: Parallel bitmap index scan |
| Previous Message | David Rowley | 2020-07-26 22:48:45 | Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. |