Re: Excessive disk usage in WindowAgg

From: Andres Freund <andres(at)anarazel(dot)de>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Excessive disk usage in WindowAgg
Date: 2019-11-04 19:11:18
Message-ID: 20191104191118.b2nvs5rrqm4nhuwd@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2019-11-04 19:04:52 +0000, Andrew Gierth wrote:
> >>>>> "Andres" == Andres Freund <andres(at)anarazel(dot)de> writes:
>
> >>> Obviously we _do_ need to be more picky about this; it seems clear
> >>> that using CP_SMALL_TLIST | CP_LABEL_TLIST would be a win in many
> >>> cases. Opinions?
>
> >> Seems reasonable to me, do you want to do the honors?
>
> Andres> I was briefly wondering if this ought to be backpatched. -0
> Andres> here, but...
>
> Uh, it seems obvious to me that it should be backpatched?

Fine with me. But I don't think it's just plainly obvious, it's
essentailly a change in query plans etc, and we've been getting more
hesitant with those over time.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2019-11-04 19:12:38 Re: v12 and pg_restore -f-
Previous Message Stephen Frost 2019-11-04 19:09:45 Re: Missed check for too-many-children in bgworker spawning