Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tngQs-00025C-C4 for pgsql-committers@arkaria.postgresql.org; Thu, 27 Feb 2025 16:08:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tngHO-00HVJj-Mj for pgsql-committers@arkaria.postgresql.org; Thu, 27 Feb 2025 15:58:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tngHO-00HVIz-FU for pgsql-committers@lists.postgresql.org; Thu, 27 Feb 2025 15:58:30 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tngHL-000Oxb-10 for pgsql-committers@lists.postgresql.org; Thu, 27 Feb 2025 15:58:29 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tngHL-0013Es-Gf for pgsql-committers@lists.postgresql.org; Thu, 27 Feb 2025 15:58:27 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tngHL-0000O9-1I for pgsql-committers@lists.postgresql.org; Thu, 27 Feb 2025 15:58:27 +0000 Content-Type: multipart/mixed; boundary="===============8014197625353053231==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Get rid of O(N^2) script-parsing overhead in pgbench. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 27 Feb 2025 15:58:27 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8014197625353053231== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 R2V0IHJpZCBvZiBPKE5eMikgc2NyaXB0LXBhcnNpbmcgb3ZlcmhlYWQgaW4gcGdiZW5jaC4KCnBn YmVuY2ggd2FudHMgdG8gcmVjb3JkIHRoZSBzdGFydGluZyBsaW5lIG51bWJlciBvZiBlYWNoIGNv bW1hbmQKaW4gaXRzIHNjcmlwdHMuICBJdCB3YXMgY29tcHV0aW5nIHRoYXQgYnkgc2Nhbm5pbmcg ZnJvbSB0aGUgc2NyaXB0CnN0YXJ0IGFuZCBjb3VudGluZyBuZXdsaW5lcywgc28gdGhhdCBPKE5e Mikgd29yayBoYWQgdG8gYmUgZG9uZQpmb3IgYW4gTi1jb21tYW5kIHNjcmlwdC4gIEluIGEgc2Ny aXB0IHdpdGggNTBLIGxpbmVzLCB0aGlzIGFkZHMKdXAgdG8gYWJvdXQgMTAgc2Vjb25kcyBvbiBt eSBtYWNoaW5lLgoKVG8gYWRkIGluc3VsdCB0byBpbmp1cnksIHRoZSByZXN1bHRzIHdlcmUgc3Vi dGx5IHdyb25nLCBiZWNhdXNlCmV4cHJfc2Nhbm5lcl9vZmZzZXQoKSBzY2FubmVkIHRvIGZpbmQg dGhlIE5VTCB0aGF0IGZsZXggaW5zZXJ0cwphdCB0aGUgZW5kIG9mIHRoZSBjdXJyZW50IHRva2Vu IC0tLSBhbmQgYmVmb3JlIHRoZSBmaXJzdCB5eWxleApjYWxsLCBubyBzdWNoIE5VTCBoYXMgYmVl biBpbnNlcnRlZC4gIFNvIHdlIGVuZGVkIGJ5IGNvbXB1dGluZyB0aGUKc2NyaXB0J3MgbGFzdCBs aW5lIG51bWJlciBub3QgaXRzIGZpcnN0IG9uZS4gIFRoaXMgd2FzIHZpc2libGUgb25seQppbiBj YXNlIG9mIFxnc2V0IGF0IHRoZSBzdGFydCBvZiBhIHNjcmlwdCwgd2hpY2ggcGVyaGFwcyBhY2Nv dW50cwpmb3IgdGhlIGxhY2sgb2YgY29tcGxhaW50cy4KClRvIGZpeCwgc3RlYWwgYW4gaWRlYSBm cm9tIHBscGdzcWwgYW5kIHRyYWNrIHRoZSBjdXJyZW50IGxleGVyCmVuZGluZyBwb3NpdGlvbiBh bmQgbGluZSBjb3VudCBhcyB3ZSBhZHZhbmNlIHRocm91Z2ggdGhlIHNjcmlwdC4KKEl0J3MgYSBi aXQgc2ltcGxlciB0aGFuIHBscGdzcWwgc2luY2Ugd2UgY2FuJ3QgbmVlZCB0byBiYWNrIHVwLikK QWxzbyBhZGp1c3QgYSBjb3VwbGUgb2Ygb3RoZXIgcGxhY2VzIHRoYXQgd2VyZSBpbnZva2luZyBz Y2Fucwpmcm9tIHNjcmlwdCBzdGFydCB3aGVuIHRoZXkgZGlkbid0IHJlYWxseSBuZWVkIHRvLiAg SSBtYWRlIGEgbmV3CnBzcWxzY2FuIGZ1bmN0aW9uIHBzcWxfc2Nhbl9nZXRfbG9jYXRpb24oKSB0 aGF0IHJlcGxhY2VzIGJvdGgKZXhwcl9zY2FubmVyX29mZnNldCgpIGFuZCBleHByX3NjYW5uZXJf Z2V0X2xpbmVubygpLCBzaW5jZSBpbgpwcmFjdGljZSBleHByX3NjYW5uZXJfZ2V0X2xpbmVubygp IHdhcyBvbmx5IGJlaW5nIGludm9rZWQgdG8gZmluZAp0aGUgbGluZSBudW1iZXIgb2YgdGhlIGN1 cnJlbnQgbGV4ZXIgZW5kIHBvc2l0aW9uLgoKUmVwb3J0ZWQtYnk6IERhbmllbCBWw6lyaXTDqSA8 ZGFuaWVsQG1hbml0b3UtbWFpbC5vcmc+CkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBh LnVzPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzg0YThhODllLWFkYjgtNDdhOS05 ZDM0LWMxM2Y3MTUwZWU0NUBtYW5pdG91LW1haWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv YzhjNzRhZDdlMWNiYzcxYjYxNmY4YWU3ODY3NzZjNTIxNzI5OTc2YgoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ2JlbmNoL2V4cHJzY2FuLmwgICAgICAgICAgfCA2NSAr KysrKysrKysrKystLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy9iaW4vcGdiZW5jaC9wZ2Jl bmNoLmMgICAgICAgICAgIHwgMTQgKysrKy0tLS0Kc3JjL2Jpbi9wZ2JlbmNoL3BnYmVuY2guaCAg ICAgICAgICAgfCAgNCArLS0Kc3JjL2ZlX3V0aWxzL3BzcWxzY2FuLmwgICAgICAgICAgICAgfCA1 NCArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL2luY2x1ZGUvZmVfdXRpbHMvcHNx bHNjYW4uaCAgICAgfCAgMyArKwpzcmMvaW5jbHVkZS9mZV91dGlscy9wc3Fsc2Nhbl9pbnQuaCB8 ICA0ICsrKwo2IGZpbGVzIGNoYW5nZWQsIDg5IGluc2VydGlvbnMoKyksIDU1IGRlbGV0aW9ucygt KQoK --===============8014197625353053231==--