Re: Merge David and Goliath tables efficiently

From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To: nicolas paris <nicolas(dot)paris(at)riseup(dot)net>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Merge David and Goliath tables efficiently
Date: 2023-06-19 11:34:45
Message-ID: 95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 6/18/23 22:57, nicolas paris wrote:
>> ...
>> Well, I kinda doubt you have 17023331531230 rows (not even physically
>> possible with 2TB disk), so that's immediately suspicious.
>
> Below is the full plan for the strategy 2.1 (Indeed the previous email
> plan was truncated and wrong, sorry for that). 
>

None of the plans has estimates anywhere close to 17023331531230, so
where did that come from?

regards

--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2023-06-19 11:53:50 Re: Merge David and Goliath tables efficiently
Previous Message Alvaro Herrera 2023-06-19 07:46:46 Re: Merge David and Goliath tables efficiently