pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: nicolas paris <nicolas.paris@riseup.net>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Merge David and Goliath tables efficiently
Date: Mon, 19 Jun 2023 13:34:45 +0200
Message-ID: <95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com> (raw)
In-Reply-To: <0e68d4e3f09ea9cf7f55f594d8f2bf47cead3cb2.camel@riseup.net>
References: <28172511-8297-4E6D-9DD0-421B5CF5240A@riseup.net>
	<c2bb0978-10ea-1644-6b72-240298fd88d7@enterprisedb.com>
	<516e9f9f56314f3d812615b7e6aadfa0bf45e418.camel@riseup.net>
	<07f2d1b3-c159-dee9-a059-1f71027fe8cd@enterprisedb.com>
	<0e68d4e3f09ea9cf7f55f594d8f2bf47cead3cb2.camel@riseup.net>



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





view thread (15+ messages)  latest in thread

Message-ID: <95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com>
Permalink:  ../95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com/
Also on:    postgresql.org/message-id/95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tomas.vondra@enterprisedb.com, nicolas.paris@riseup.net, pgsql-performance@lists.postgresql.org
  Subject: Re: Merge David and Goliath tables efficiently
  In-Reply-To: <95de26a3-c2cf-9e8b-de76-a14630553ff3@enterprisedb.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox