Re: Incorrect cost for MergeAppend

From: Alexander Kuzmenkov <akuzmenkov(at)timescale(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incorrect cost for MergeAppend
Date: 2024-01-30 13:23:37
Message-ID: CALzhyqw92t2SfY5nREa+zm6E0r3s4R28qZCqn2pE8=-nscOouw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 30, 2024 at 1:20 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> You should likely focus on trying to find a test that does not require
> making 2 tables with 10k rows.

Is 1k smallint OK? It should fit in one page. Still reproduces the
error, and the entire test case runs in under 10 ms.

Attachment Content-Type Size
merge-append-cost-v2.patch text/x-patch 2.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Quan Zongliang 2024-01-30 13:25:35 Re: Improvement discussion of custom and generic plans
Previous Message Илья Евдокимов 2024-01-30 13:20:58 pg_stat_advisor extension