Re: Merge David and Goliath tables efficiently - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: Merge David and Goliath tables efficiently
Date
Msg-id 95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com
Whole thread Raw
In response to Re: Merge David and Goliath tables efficiently  (nicolas paris <nicolas.paris@riseup.net>)
Responses Re: Merge David and Goliath tables efficiently  (nicolas paris <nicolas.paris@riseup.net>)
List 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



pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Merge David and Goliath tables efficiently
Next
From: Tomas Vondra
Date:
Subject: Re: Merge David and Goliath tables efficiently