Re: Excessive disk usage in WindowAgg

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

Andres Freund <andres(at)anarazel(dot)de> writes:
> On 2019-11-04 19:04:52 +0000, Andrew Gierth wrote:
>> 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.

Since this is happening during create_plan(), it affects no planner
decisions; it's just a pointless inefficiency AFAICS. Back-patching
seems fine.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-11-04 19:24:29 Re: v12 and pg_restore -f-
Previous Message Alvaro Herrera 2019-11-04 19:12:38 Re: v12 and pg_restore -f-