Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m1bRE-0001Ar-3i for pgsql-performance@arkaria.postgresql.org; Thu, 08 Jul 2021 21:20:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1bRC-0004NG-Vc for pgsql-performance@arkaria.postgresql.org; Thu, 08 Jul 2021 21:20:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m1bRC-0004N7-L0 for pgsql-performance@lists.postgresql.org; Thu, 08 Jul 2021 21:20:02 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m1bR6-00024z-7Z for pgsql-performance@lists.postgresql.org; Thu, 08 Jul 2021 21:20:02 +0000 Received: by mail-qv1-xf32.google.com with SMTP id o6so1795905qvw.0 for ; Thu, 08 Jul 2021 14:19:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=5ZKXCxpHc3pSE7myY5JTOx5WMDzZs8aND/vJxnpjXug=; b=Y5dBEbElWjE23BSfpD3BxhfoFAySZeeFpJdubBKkw/veQpgWfGUB0eY2YtI0ymSPVF 9emL+10k+5jc5Dk/3szbz/B4Izj6bZyYVrDMd4JK1p8tpjMw54Vgz9Imnj+j4KUvB4+G ZXbOz9cjg/EOEd/fj+/SZ/leRUN3QEaeLdJfavGQVuViYLl+OJ9GlEdHQJRrWY7xFqPg D5d98kAbFdojvA1AVKZbAo8PQpegHU99tLg26FVGjSKbTdt31OVbcGzrHqv4d8QCOEK6 btomjx3N3+HztrwlVNo8T6X6IUEmJ5k0OSiYtBBfSS4pe8d2pscFhVlmhvN1qJi7Ovxu w5nw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=5ZKXCxpHc3pSE7myY5JTOx5WMDzZs8aND/vJxnpjXug=; b=p7n6sNUMnnp/ERIwD8ekZ5EnNR4ufi/6ZYKc7cxp92ian52esF5HkuDMiMXo8jhSca TF8hRQw0GWcmYY9zeOcAg+4hTQu9/H0fDAL4/8WAhP7acE0xM+4Wn1AcXGM3SuTy4THI XpLtfYZZsgtYrtVOkg7OotTEZoMVi5KrmzU71nN5kuxGzIUxNp70foH+0hJSPPEUSWlz 5Qgw2SJ5SbgEZX1StHunRz/D4AZtmat06uZYHVF6YOqWadzFn1FmoQdR7xuyRQWDOizS 26fy+y5Hm6LtuHTYriyXLfAzSIJ7mO6jYh7oD76xVrhvFg1p1oDv++WMfFbEr9Q2zDlt Y0ng== X-Gm-Message-State: AOAM531gxJY9IULn4Am6XcKcpdXzsaCZXh0o2NJLtW8TMifQXYWr8bZo EJ0lVxp9+nuLPdxPhXDR0Sc= X-Google-Smtp-Source: ABdhPJz/2TXnaYBvi8V7J8geUhUzwTWWS5SX5HPiLtwJJUJAOV7GSeaOy8uFchtJUUd+xLBinBWxRA== X-Received: by 2002:a05:6214:410f:: with SMTP id kc15mr11420531qvb.50.1625779191193; Thu, 08 Jul 2021 14:19:51 -0700 (PDT) Received: from smtpclient.apple (190-21-57-162.baf.movistar.cl. [190.21.57.162]) by smtp.gmail.com with ESMTPSA id l14sm1468992qtj.26.2021.07.08.14.19.50 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 08 Jul 2021 14:19:50 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.100.0.2.22\)) Subject: Re: Strange execution plan From: Manuel Weitzman In-Reply-To: <9F9D5E5E-6C58-4815-A20A-84216B788AD1@gmail.com> Date: Thu, 8 Jul 2021 17:19:48 -0400 Cc: Pgsql Performance Content-Transfer-Encoding: 7bit Message-Id: <7BF94AFA-A310-4498-AE14-BE96174C8EB0@gmail.com> References: <17a8539f896.10fc10eb5173534.6306217358025168810@car-expresso.com> <9F9D5E5E-6C58-4815-A20A-84216B788AD1@gmail.com> To: Joel Frid X-Mailer: Apple Mail (2.3654.100.0.2.22) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 08-07-2021, at 17:13, Manuel Weitzman wrote: > > I'd recommend you using cursors for pagination in general (I know it > may not be possible for you, just wanted to explain as it could be > useful). By the way, I mean cursor pagination as the general concept. I'm not talking about Postgres cursors. Best regards, Manuel Weitzman