Re: Merge David and Goliath tables efficiently

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Merge David and Goliath tables efficiently
Дата
Msg-id 95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Merge David and Goliath tables efficiently  (nicolas paris <nicolas.paris@riseup.net>)
Ответы Re: Merge David and Goliath tables efficiently  (nicolas paris <nicolas.paris@riseup.net>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Merge David and Goliath tables efficiently
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Merge David and Goliath tables efficiently