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 1ken3r-0002we-7Y for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Nov 2020 22:33:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ken3p-0006Nz-1M for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Nov 2020 22:33:21 +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 1ken3o-0006Ns-Qg for pgsql-hackers@lists.postgresql.org; Mon, 16 Nov 2020 22:33:20 +0000 Received: from mta97aws110.mxout.inova.com.br ([3.223.97.110] helo=mxhero01.a.inova.com.br) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ken3j-00036v-54 for pgsql-hackers@postgresql.org; Mon, 16 Nov 2020 22:33:20 +0000 Received: from ip-10-0-4-78.ec2.internal (localhost [127.0.0.1]) by mxhero01.a.inova.com.br (Postfix) with ESMTP id BE5F51E62FF for ; Mon, 16 Nov 2020 22:33:11 +0000 (UTC) Received: from corpmoutpolicyd01.a.inova.com.br (puppetmaster.a.inova.com.br [10.0.1.88]) by mxhero01.a.inova.com.br (Postfix) with ESMTP; Mon, 16 Nov 2020 22:33:11 +0000 (UTC) Received: from corpmoutpolicyd01.a.inova.com.br (localhost [127.0.0.1]) by corpmoutpolicyd01.a.inova.com.br (Postfix) with ESMTP id 9A5A92204D7; Mon, 16 Nov 2020 20:33:07 -0200 (BRST) Received: from corpmout01.a.inova.com.br (ip-10-0-1-125.ec2.internal [10.0.1.125]) by corpmoutpolicyd01.a.inova.com.br (Postfix) with ESMTP id 8F1AAE057A; Mon, 16 Nov 2020 20:33:07 -0200 (BRST) Received: from corpmbox02.a.inova.com.br (ip-10-0-4-158.ec2.internal [10.0.4.158]) by corpmout01.a.inova.com.br (Postfix) with ESMTP; Mon, 16 Nov 2020 19:33:07 -0300 (-03) Date: Mon, 16 Nov 2020 19:33:07 -0300 (BRT) From: luis.roberto@siscobra.com.br To: Tomas Vondra Cc: James Coleman , Jaime Casanova , Pg Hackers Message-ID: <991884329.69403168.1605565987239.JavaMail.zimbra@siscobra.com.br> In-Reply-To: <20201103213942.sj3qohewdshrw4oz@development> References: <20201029220652.glf4xk2p7wkfisb6@development> <20201030210316.cbwv4arwp4lcfgx2@development> <20201103023743.sswkl6h74dkbcfmp@development> <20201103213942.sj3qohewdshrw4oz@development> Subject: Re: enable_incremental_sort changes query behavior MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_430a7192-3902-494a-9a96-3648a8131068" X-Originating-IP: [10.0.4.158] X-Mailer: Zimbra 8.8.15_GA_3968 (ZimbraWebClient - GC86 (Win)/8.8.15_GA_3968) Thread-Topic: enable_incremental_sort changes query behavior Thread-Index: 6vmI3TmTW9MgyQKWDavrE4kYGiGZPw== x-mxHero-Origin-Ip: /127.0.0.1:58630 X-mxHero-AttachmentBlock: rule=48;result=false List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_430a7192-3902-494a-9a96-3648a8131068 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit I've pushed the 0001 part, i.e. the main fix. Not sure about the other parts (comments and moving the code back to postgres_fdw) yet. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services Hi, Tomas! I'm still having trouble with this problem. Tom commited something [1] to avoid core dumps, but all I get now is: subplan "SubPlan 1" was not initialized I upgraded to 13.1 over the weekend but the problem still occurs. This is the topic I started: https://www.postgresql.org/message-id/flat/CAAaqYe--qpnBOUiqnHSAc71K2HpXetnGedRAX0Z04zx%3DY0ExHA%40mail.gmail.com#8cb6c7c5e787d2d3d2dc7aaf00d1cae8 [1] https://git.postgresql.org/pg/commitdiff/936043c9eacb9e9c7356a8190a410d2c4e4ea03a --=_430a7192-3902-494a-9a96-3648a8131068 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

I've pushed the 0001 part, i.= e. the main fix. Not sure about the other
parts (comments and moving the= code back to postgres_fdw) yet.


regards

--
Tomas Von= dra                  http://ww= w.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Trai= ning & Services

Hi, Tomas!

I'm still having trouble with this problem. Tom commited something [1] to = avoid core dumps, but all I get now is: subplan "SubPlan 1"  was not i= nitialized

I upgraded to 13.1= over the weekend but the problem still occurs. 

This is the topic I started: https://www.post= gresql.org/message-id/flat/CAAaqYe--qpnBOUiqnHSAc71K2HpXetnGedRAX0Z04zx%3DY= 0ExHA%40mail.gmail.com#8cb6c7c5e787d2d3d2dc7aaf00d1cae8



[1] https://git.postgresql.org/pg/commitdiff/936043c9eacb9e9c7356a8= 190a410d2c4e4ea03a

--=_430a7192-3902-494a-9a96-3648a8131068--