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 1m1R7R-0001WM-AV for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Jul 2021 10:18:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1R7Q-0001qw-46 for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Jul 2021 10:18:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m1R7P-0001pX-Rl for pgsql-bugs@lists.postgresql.org; Thu, 08 Jul 2021 10:18:55 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1R7M-0004P8-Hx for pgsql-bugs@lists.postgresql.org; Thu, 08 Jul 2021 10:18:54 +0000 Received: from Andreys-MacBook-Pro.local (unknown [88.135.91.49]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id BCA0321C8972; Thu, 8 Jul 2021 13:18:49 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1625739529; bh=KrA7vUUPeo/Y3t09UyLMERchr89Hp7cFKi9j5tzPxjA=; h=Subject:To:Cc:References:From:Date:In-Reply-To; b=eFBq+MxxlUwI6Qrh5eMzMgqEs5blDJEnSYN+8SbKZr8Ix0tOhJmIyOBTZkH1Djezp oL4UQRN+hFfQTvh/Zavqba3ZVUDUQCcZsVZMNKBcb3n44pxGNSwvBeUH9HHVQ8sIec pobb2wim/ocV7J/cF3IEcUaIO9uhmsJh7tz6qNfg= Subject: Re: The case when AsyncAppend exists also in the qual of Async ForeignScan To: Etsuro Fujita Cc: PostgreSQL mailing lists References: From: Andrey Lepikhov Organization: Postgres Professional Message-ID: <138b2b22-1f3e-5222-4eb6-86c562eeea8d@postgrespro.ru> Date: Thu, 8 Jul 2021 13:18:49 +0300 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/mixed; boundary="------------1F5A1BC2900BD3D20C364F69" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1F5A1BC2900BD3D20C364F69 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 8/7/21 10:49, Etsuro Fujita wrote: > I tried to reproduce this in my environment using HEAD and PG14, but I > couldn't. Could you elaborate a bit more on how to reproduce this? Interesting... I use the only script (see t.sql) right after the instance has started. Output see in t.out All my specific preferences: autovacuum = 'off' max_worker_processes = 64 max_parallel_workers_per_gather = 16 max_parallel_workers = 32 parallel_setup_cost = 100 parallel_tuple_cost = 0.05 min_parallel_table_scan_size = 0 -- regards, Andrey Lepikhov Postgres Professional --------------1F5A1BC2900BD3D20C364F69 Content-Type: application/sql; x-mac-type="0"; x-mac-creator="0"; name="t.sql" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="t.sql" RFJPUCBUQUJMRSAgSUYgRVhJU1RTIHRlc3QsdDAsdGVzdF8xLHRlc3RfMix0MF8xLHQwXzIg Q0FTQ0FERTsKRFJPUCBFWFRFTlNJT04gSUYgRVhJU1RTIHBvc3RncmVzX2ZkdyBDQVNDQURF OwoKQ1JFQVRFIEVYVEVOU0lPTiBwb3N0Z3Jlc19mZHc7CkNSRUFURSBTRVJWRVIgbGIxIEZP UkVJR04gREFUQSBXUkFQUEVSIHBvc3RncmVzX2ZkdyBPUFRJT05TIChhc3luY19jYXBhYmxl ICd0cnVlJyk7CkNSRUFURSBTRVJWRVIgbGIyIEZPUkVJR04gREFUQSBXUkFQUEVSIHBvc3Rn cmVzX2ZkdyBPUFRJT05TIChhc3luY19jYXBhYmxlICd0cnVlJyk7CkNSRUFURSBVU0VSIE1B UFBJTkcgRk9SIFBVQkxJQyBTRVJWRVIgbGIxOwpDUkVBVEUgVVNFUiBNQVBQSU5HIEZPUiBQ VUJMSUMgU0VSVkVSIGxiMjsKCkNSRUFURSBUQUJMRSB0ZXN0ICh4IGludCkgUEFSVElUSU9O IEJZIEhBU0ggKHgpOwpDUkVBVEUgVEFCTEUgdGVzdF8xICh4IGludCk7CkNSRUFURSBUQUJM RSB0ZXN0XzIgKHggaW50KTsKQ1JFQVRFIEZPUkVJR04gVEFCTEUgZnRlc3RfMSBQQVJUSVRJ T04gT0YgdGVzdAoJRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDIsIHJlbWFpbmRlciAwKQoJ U0VSVkVSIGxiMSBPUFRJT05TICh0YWJsZV9uYW1lICd0ZXN0XzEnKTsKQ1JFQVRFIEZPUkVJ R04gVEFCTEUgZnRlc3RfMiBQQVJUSVRJT04gT0YgdGVzdAoJRk9SIFZBTFVFUyBXSVRIICht b2R1bHVzIDIsIHJlbWFpbmRlciAxKQoJU0VSVkVSIGxiMiBPUFRJT05TICh0YWJsZV9uYW1l ICd0ZXN0XzInKTsKSU5TRVJUIElOVE8gdGVzdCAoU0VMRUNUICogRlJPTSBnZW5lcmF0ZV9z ZXJpZXMoMSwxMCkpOwoKQU5BTFlaRSB0ZXN0LHRlc3RfMSx0ZXN0XzI7CgpFWFBMQUlOIEFO QUxZWkUgdmVyYm9zZQpTRUxFQ1QgKiBGUk9NIHRlc3QgV0hFUkUgeCBOT1QgSU4gKAoJU0VM RUNUIGF2Zyh4KSBGUk9NIHRlc3QgV0hFUkUgeCA+IDEwCik7 --------------1F5A1BC2900BD3D20C364F69 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="t.out" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="t.out" cHNxbCAtZiB0LnNxbCAKRFJPUCBUQUJMRQpwc3FsOnQuc3FsOjI6IE5PVElDRTogIGRyb3Ag Y2FzY2FkZXMgdG8gNCBvdGhlciBvYmplY3RzCkRFVEFJTDogIGRyb3AgY2FzY2FkZXMgdG8g c2VydmVyIGxiMQpkcm9wIGNhc2NhZGVzIHRvIHVzZXIgbWFwcGluZyBmb3IgcHVibGljIG9u IHNlcnZlciBsYjEKZHJvcCBjYXNjYWRlcyB0byBzZXJ2ZXIgbGIyCmRyb3AgY2FzY2FkZXMg dG8gdXNlciBtYXBwaW5nIGZvciBwdWJsaWMgb24gc2VydmVyIGxiMgpEUk9QIEVYVEVOU0lP TgpDUkVBVEUgRVhURU5TSU9OCkNSRUFURSBTRVJWRVIKQ1JFQVRFIFNFUlZFUgpDUkVBVEUg VVNFUiBNQVBQSU5HCkNSRUFURSBVU0VSIE1BUFBJTkcKQ1JFQVRFIFRBQkxFCkNSRUFURSBU QUJMRQpDUkVBVEUgVEFCTEUKQ1JFQVRFIEZPUkVJR04gVEFCTEUKQ1JFQVRFIEZPUkVJR04g VEFCTEUKSU5TRVJUIDAgMTAKQU5BTFlaRQpwc3FsOnQuc3FsOjI2OiBFUlJPUjogIEluc3Ry RW5kTG9vcCBjYWxsZWQgb24gcnVubmluZyBub2RlCg== --------------1F5A1BC2900BD3D20C364F69--