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 1tLJ8T-00E192-0X for pgsql-committers@arkaria.postgresql.org; Wed, 11 Dec 2024 09:36:01 +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 1tLJ8Q-00Em7C-6k for pgsql-committers@arkaria.postgresql.org; Wed, 11 Dec 2024 09:35:59 +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 1tLJ8P-00Em73-Um for pgsql-committers@lists.postgresql.org; Wed, 11 Dec 2024 09:35:59 +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.94.2) (envelope-from ) id 1tLJ8K-002Ekv-CK for pgsql-committers@lists.postgresql.org; Wed, 11 Dec 2024 09:35:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=H6vNPaYE2B8ZG85VKDOyMsmifKRrYz5T32i7ikkwTm0=; b=jAEwz86HVZhwy/hXOJBGmLynHm quUPZpXAj8IwK7YvpEXl8OIjl/ubpxcU7bECAAcY6TBagqC05aNxaNTTuvyVlYwdkCo5TqLiV4+pD 9NDtfPRnblTnWR+RGpCUTPPO+l2ZqO60CaUpzc03Xma7lTcFSpxeT1biFM3hU1HkrsGLfxgVixvcj km6YEUotFNgxM5eUmU2+PXpeUlNUpKpqpvnIgp2140SUvBQHPmQliZ9IyF/XEwAWZaXTrY2fT2qZ9 4ad6sl4KwGJyaZ1KzQQyDLKAVwdNK71JfI+DXT96R/CjaJRfPdIjVUAosH9dSm8BgGLTWsB4jMFJm lTXfvGsQ==; 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 1tLJ8J-006wzN-Mg for pgsql-committers@lists.postgresql.org; Wed, 11 Dec 2024 09:35:51 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tLJ8I-002ApU-7t for pgsql-committers@lists.postgresql.org; Wed, 11 Dec 2024 09:35:50 +0000 Content-Type: multipart/mixed; boundary="===============0539485073967844541==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Enable BUFFERS with EXPLAIN ANALYZE by default X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 11 Dec 2024 09:35:50 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0539485073967844541== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5hYmxlIEJVRkZFUlMgd2l0aCBFWFBMQUlOIEFOQUxZWkUgYnkgZGVmYXVsdAoKVGhlIHRvcGlj IG9mIHR1cm5pbmcgRVhQTEFJTidzIEJVRkZFUlMgb3B0aW9uIG9uIHdpdGggdGhlIEFOQUxZWkUg b3B0aW9uCmhhcyBjb21lIHVwIGEgZmV3IHRpbWVzIG92ZXIgdGhlIHBhc3QgZmV3IHllYXJzLiAg SW4gbWFueSB3YXlzLCBkb2luZyB0aGlzCnNlZW1zIGxpa2UgYSBnb29kIGlkZWEgYXMgaXQgbWF5 IGJlIG1vcmUgb2J2aW91cyB0byB1c2VycyB3aHkgYSBnaXZlbgpxdWVyeSBpcyBydW5uaW5nIG1v cmUgc2xvd2x5IHRoYW4gdGhleSBtaWdodCBleHBlY3QuICBBbHNvLCBmcm9tIG15IG93bgooRGF2 aWQncykgcGVyc29uYWwgZXhwZXJpZW5jZSwgSSd2ZSBzZWVuIHVzZXJzIHBvc3RpbmcgdG8gdGhl IG1haWxpbmcKbGlzdHMgd2l0aCB0d28gaWRlbnRpY2FsIHBsYW5zLCBvbmUgc2xvdyBhbmQgb25l IGZhc3QgYXNraW5nIHdoeSB0aGVpcgpxdWVyeSBpcyBzb21ldGltZXMgc2xvdy4gIEluIG1hbnkg Y2FzZXMsIHRoaXMgaXMgZHVlIHRvIGFkZGl0aW9uYWwgcmVhZHMuCkhhdmluZyBCVUZGRVJTIG9u IGJ5IGRlZmF1bHQgbWF5IGhlbHAgcmVkdWNlIHNvbWUgb2YgdGhlc2UgcXVlc3Rpb25zLCBhbmQK aWYgbm90LCBtYWtlIGl0IG1vcmUgb2J2aW91cyB0byB0aGUgdXNlciBiZWZvcmUgdGhleSBwb3N0 LCBvciBzYXZlIGEKcm91bmQtdHJpcCB0byB0aGUgbWFpbGluZyBsaXN0IHdoZW4gYWRkaXRpb25h bCBJL08gZWZmb3J0IGlzIHRoZSBjYXVzZSBvZgp0aGUgc2xvd25lc3MuCgpUaGUgZ2VuZXJhbCBj b25zZW5zdXMgaXMgdGhhdCB3ZSB3YW50IEJVRkZFUlMgb24gYnkgZGVmYXVsdCB3aXRoCkFOQUxZ WkUuICBIb3dldmVyLCB0aGVyZSB3ZXJlIG1vcmUgdGhhbiB6ZXJvIGNvbmNlcm5zIHJhaXNlZCB3 aXRoIGRvaW5nCnNvLiAgVGhlIHByaW1hcnkgcmVhc29uIGFnYWluc3QgaXMgdGhlIGFkZGl0aW9u YWwgdmVyYm9zaXR5LCBtYWtpbmcgaXQKaGFyZGVyIHRvIHJlYWQgbGFyZ2UgcGxhbnMuICBBbm90 aGVyIGNvbmNlcm4gd2FzIHRoYXQgYnVmZmVyIGluZm9ybWF0aW9uCmlzbid0IGFsd2F5cyB1c2Vm dWwgc28gbWF5IG5vdCBtYWtlIHNlbnNlIHRvIGhhdmUgaXQgb24gYnkgZGVmYXVsdC4KCkl0J3Mg Y3VycmVudGx5IERlY2VtYmVyLCBzbyBsZXQncyBjb21taXQgdGhpcyB0byBzZWUgaWYgYW55b25l IGNvbWVzCmZvcndhcmQgd2l0aCBhIHN0cm9uZyBvYmplY3Rpb24gYWdhaW5zdCBtYWtpbmcgdGhp cyBjaGFuZ2UuICBXZSBoYXZlIG92ZXIKaGFsZiBhIHllYXIgcmVtYWluaW5nIGluIHRoZSB2MTgg Y3ljbGUgd2hlcmUgd2UgY291bGQgc3RpbGwgZWFzaWx5IGNvbnNpZGVyCnJldmVydGluZyB0aGlz IGlmIHNvbWVvbmUgd2VyZSB0byBjb21lIGZvcndhcmQgd2l0aCBhIGNvbnZpbmNpbmcgZW5vdWdo CnJlYXNvbiBhcyB0byB3aHkgZG9pbmcgdGhpcyBpcyBhIGJhZCBpZGVhLgoKVGhlcmUgd2VyZSB0 d28gcGF0Y2hlcyBpbmRlcGVuZGVudGx5IHN1Ym1pdHRlZCB0byBhY2hpZXZlIHRoaXMgZ29hbCwg b25lCmJ5IG1lIGFuZCB0aGUgb3RoZXIgYnkgR3VpbGxhdW1lLiAgVGhpcyBjb21taXQgaXMgYSBt aXggb2YgYm90aCBvZiB0aGVzZQpwYXRjaGVzIHdpdGggc29tZSBhZGRpdGlvbmFsIHdvcmsgZG9u ZSBieSBtZSB0byBhZGp1c3QgdmFyaW91cwphZGRpdGlvbmFsIHBsYWNlcyBpbiB0aGUgZG9jdW1l bnRhdGlvbiB3aGljaCBpbmNsdWRlIEVYUExBSU4gQU5BTFlaRQpvdXRwdXQuCgpBdXRob3I6IEd1 aWxsYXVtZSBMZWxhcmdlLCBEYXZpZCBSb3dsZXkKUmV2aWV3ZWQtYnk6IFJvYmVydCBIYWFzLCBH cmVnIFNhYmlubyBNdWxsYW5lLCBNaWNoYWVsIENocmlzdG9maWRlcwpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tL0NBTk5NTysrVzdNTThUMEt5WE4zWmhlWFh0LXVMVk0zYUV0WmQrV05m Wj1vYnhmZlVpQUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2MyYTQwNzhl YmFkNzE5OTlkZDQ1MWFlN2Q0MzU4YmUzYzkyOTBiMDcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCmNvbnRyaWIvcG9zdGdyZXNfZmR3L2V4cGVjdGVkL3Bvc3RncmVzX2Zkdy5vdXQgfCAg OCArLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvc3FsL3Bvc3RncmVzX2Zkdy5zcWwgICAgICB8ICA4 ICstLQpkb2Mvc3JjL3NnbWwvYmxvb20uc2dtbCAgICAgICAgICAgICAgICAgICAgICAgIHwgMTYg KysrLS0KZG9jL3NyYy9zZ21sL2ppdC5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgICB8ICA1 ICstCmRvYy9zcmMvc2dtbC9wZXJmb3JtLnNnbWwgICAgICAgICAgICAgICAgICAgICAgfCA0NCAr KysrKysrKy0tLS0KZG9jL3NyYy9zZ21sL3BsYW5zdGF0cy5zZ21sICAgICAgICAgICAgICAgICAg ICB8IDE4ICsrLS0tCmRvYy9zcmMvc2dtbC9yZWYvZXhwbGFpbi5zZ21sICAgICAgICAgICAgICAg ICAgfCAxMCArKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvZXhwbGFpbi5jICAgICAgICAgICAgICAg ICB8ICA3ICsrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYnJpbl9tdWx0aS5vdXQgICAgICAg fCAxOCArKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2V4cGxhaW4ub3V0ICAgICAgICAg IHwgMzggKysrKysrKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luY3JlbWVudGFsX3Nv cnQub3V0IHwgIDQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9tZW1vaXplLm91dCAgICAg ICAgICB8ICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWVyZ2Uub3V0ICAgICAgICAg ICAgfCAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3BhcnRpdGlvbl9wcnVuZS5vdXQg IHwgOTYgKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9zZWxlY3Qub3V0ICAgICAgICAgICB8ICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv c2VsZWN0X2ludG8ub3V0ICAgICAgfCAgNCArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3Nl bGVjdF9wYXJhbGxlbC5vdXQgIHwgIDYgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdWJz ZWxlY3Qub3V0ICAgICAgICB8ICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGlkc2Nh bi5vdXQgICAgICAgICAgfCAgNiArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9icmluX211bHRpLnNx bCAgICAgICAgICAgIHwgMTggKystLS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZXhwbGFpbi5zcWwg ICAgICAgICAgICAgICB8IDE2ICsrLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2luY3JlbWVudGFs X3NvcnQuc3FsICAgICAgfCAgNCArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9tZW1vaXplLnNxbCAg ICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvbWVyZ2Uuc3FsICAgICAg ICAgICAgICAgICB8ICAyICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3BhcnRpdGlvbl9wcnVuZS5z cWwgICAgICAgfCA5NiArKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNz L3NxbC9zZWxlY3Quc3FsICAgICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9z cWwvc2VsZWN0X2ludG8uc3FsICAgICAgICAgICB8ICA0ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L3NlbGVjdF9wYXJhbGxlbC5zcWwgICAgICAgfCAgNiArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9z dWJzZWxlY3Quc3FsICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvdGlk c2Nhbi5zcWwgICAgICAgICAgICAgICB8ICA2ICstCjMwIGZpbGVzIGNoYW5nZWQsIDI1NyBpbnNl cnRpb25zKCspLCAxOTcgZGVsZXRpb25zKC0pCgo= --===============0539485073967844541==--