Re: Trouble with hashagg spill I/O pattern and costing

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Trouble with hashagg spill I/O pattern and costing
Date: 2020-05-21 17:05:25
Message-ID: CA+TgmoYJQ3cLbgNSPGTBNykrF3ri_LQ232QiiaC8rNNa5=47PA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 21, 2020 at 10:45 AM Tomas Vondra
<tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
> So the pre-allocation makes it 10x faster, and the tlist tweak makes it
> 5x faster. Not bad, I guess.

That is pretty great stuff, Tomas.

FWIW, I agree that CP_SMALL_TLIST seems like the right thing here.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Piotr Stefaniak 2020-05-21 17:39:03 Re: pg_bsd_indent and -Wimplicit-fallthrough
Previous Message Pantelis Theodosiou 2020-05-21 14:50:12 Re: PostgreSQL 13 Beta 1 Release Announcement Draft