Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcJ6X-0003x9-UC for pgsql-committers@arkaria.postgresql.org; Sun, 16 Jun 2019 00:33:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hcJ6W-0001DS-QJ for pgsql-committers@arkaria.postgresql.org; Sun, 16 Jun 2019 00:33:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcHz6-0002oZ-H6 for pgsql-committers@lists.postgresql.org; Sat, 15 Jun 2019 23:21:20 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcHz3-0007fc-O1 for pgsql-committers@lists.postgresql.org; Sat, 15 Jun 2019 23:21:19 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcHz3-0002ad-88 for pgsql-committers@lists.postgresql.org; Sat, 15 Jun 2019 23:21:17 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.89) (envelope-from ) id 1hcHz2-0005mY-5A for pgsql-committers@lists.postgresql.org; Sat, 15 Jun 2019 23:21:16 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@lists.postgresql.org From: Tomas Vondra Subject: pgsql: Rework the pg_statistic_ext catalog Message-Id: Date: Sat, 15 Jun 2019 23:21:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk UmV3b3JrIHRoZSBwZ19zdGF0aXN0aWNfZXh0IGNhdGFsb2cKClNpbmNlIGV4dGVuZGVkIHN0YXRp c3RpYyBnb3QgaW50cm9kdWNlZCBpbiBQb3N0Z3JlU1FMIDEwLCB0aGVyZSB3YXMgYQpzaW5nbGUg Y2F0YWxvZyBwZ19zdGF0aXN0aWNfZXh0IHN0b3JpbmcgYm90aCB0aGUgZGVmaW5pdGlvbnMgYW5k IGJ1aWx0CnN0YXRpc3RpYy4gIFRoYXQncyBob3dldmVyIHByb2JsZW1hdGljIHdoZW4gYSB1c2Vy IGlzIHN1cHBvc2VkIHRvIGhhdmUKYWNjZXNzIG9ubHkgdG8gdGhlIGRlZmluaXRpb25zLCBidXQg bm90IHRvIHVzZXIgZGF0YS4KCkNvbnNpZGVyIGZvciBleGFtcGxlIHBnX2R1bXAgb24gYSBkYXRh YmFzZSB3aXRoIFJMUyBlbmFibGVkIC0gaWYgdGhlCnBnX3N0YXRpc3RpY19leHQgY2F0YWxvZyBy ZXNwZWN0cyBSTFMgKHdoaWNoIGl0IHNob3VsZCwgaWYgaXQgY29udGFpbnMKdXNlciBkYXRhKSwg cGdfZHVtcCB3b3VsZCBub3Qgc2VlIGFueSByZWNvcmRzIGFuZCB0aGUgcmVzdWx0IHdvdWxkIG5v dApkZWZpbmUgYW55IGV4dGVuZGVkIHN0YXRpc3RpY3MuICBUaGF0IHdvdWxkIGJlIGEgc3VycHJp c2luZyBiZWhhdmlvci4KClVudGlsIG5vdyB0aGlzIHdhcyBub3QgYSBwcmVzc2luZyBpc3N1ZSwg YmVjYXVzZSB0aGUgZXhpc3RpbmcgdHlwZXMgb2YKZXh0ZW5kZWQgc3RhdGlzdGljIChmdW5jdGlv bmFsIGRlcGVuZGVuY2llcyBhbmQgbmRpc3RpbmN0IGNvZWZmaWNpZW50cykKZG8gbm90IGluY2x1 ZGUgYW55IHVzZXIgZGF0YSBkaXJlY3RseS4gIFRoaXMgY2hhbmdlZCB3aXRoIGludHJvZHVjdGlv bgpvZiBNQ1YgbGlzdHMsIHdoaWNoIGRvIGluY2x1ZGUgbW9zdCBjb21tb24gY29tYmluYXRpb25z IG9mIHZhbHVlcy4KClRoZSBlYXNpZXN0IHdheSB0byBmaXggdGhpcyBpcyB0byBzcGxpdCB0aGUg cGdfc3RhdGlzdGljX2V4dCBjYXRhbG9nCmludG8gdHdvIC0gb25lIGZvciBkZWZpbml0aW9ucywg b25lIGZvciB0aGUgYnVpbHQgc3RhdGlzdGljIHZhbHVlcy4KVGhlIG5ldyBjYXRhbG9nIGlzIGNh bGxlZCBwZ19zdGF0aXN0aWNfZXh0X2RhdGEsIGFuZCB3ZSdyZSBtYWludGFpbmluZwphIDE6MSBy ZWxhdGlvbnNoaXAgd2l0aCB0aGUgb2xkIGNhdGFsb2cgLSBlaXRoZXIgdGhlcmUgYXJlIG1hdGNo aW5nCnJlY29yZHMgaW4gYm90aCBjYXRhbG9ncywgb3IgbmVpdGhlciBvZiB0aGVtLgoKQnVtcGVk IENBVFZFUlNJT04gZHVlIHRvIGNoYW5naW5nIHN5c3RlbSBjYXRhbG9nIGRlZmluaXRpb25zLgoK QXV0aG9yOiBEZWFuIFJhc2hlZWQsIHdpdGggaW1wcm92ZW1lbnRzIGJ5IG1lClJldmlld2VkLWJ5 OiBEZWFuIFJhc2hlZWQsIEpvaG4gTmF5bG9yCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vQ0FFWkFUQ1VoVDlydDdVaSUzRFZkeDROJTNEJTNEVlY1WE9LNWRzWGZuR2dWT3pfSmhBaWNC JTNEWkElNDBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzZjYmZiNzg0YzNj OTExNDYxNDhhNzZkNTBjZGE2ZjY5YWU2YTc5ZmIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAgfCA3MCArKysr KysrKysrKysrKysrKysrKysrLS0tLS0KZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbCAgICAgICAgICAg ICAgICAgICAgICB8ICA2ICstLQpkb2Mvc3JjL3NnbWwvcGVyZm9ybS5zZ21sICAgICAgICAgICAg ICAgICAgIHwgMjAgKysrKy0tLS0KZG9jL3NyYy9zZ21sL3BsYW5zdGF0cy5zZ21sICAgICAgICAg ICAgICAgICB8ICA0ICstCnNyYy9iYWNrZW5kL2NhdGFsb2cvTWFrZWZpbGUgICAgICAgICAgICAg ICAgfCAgMiArLQpzcmMvYmFja2VuZC9jb21tYW5kcy9zdGF0c2NtZHMuYyAgICAgICAgICAgIHwg NzMgKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0 aWwvcGxhbmNhdC5jICAgICAgICB8IDEyICsrKy0tCnNyYy9iYWNrZW5kL3N0YXRpc3RpY3MvUkVB RE1FLm1jdiAgICAgICAgICAgfCAgOSArKy0tCnNyYy9iYWNrZW5kL3N0YXRpc3RpY3MvZGVwZW5k ZW5jaWVzLmMgICAgICAgfCAgNyArLS0Kc3JjL2JhY2tlbmQvc3RhdGlzdGljcy9leHRlbmRlZF9z dGF0cy5jICAgICB8IDYxICsrKysrKysrKysrKystLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9zdGF0 aXN0aWNzL21jdi5jICAgICAgICAgICAgICAgIHwgIDcgKy0tCnNyYy9iYWNrZW5kL3N0YXRpc3Rp Y3MvbXZkaXN0aW5jdC5jICAgICAgICAgfCAgNyArLS0Kc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUv c3lzY2FjaGUuYyAgICAgICAgICB8IDEyICsrKysrCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVy c2lvbi5oICAgICAgICAgICAgfCAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2luZGV4aW5nLmgg ICAgICAgICAgICAgIHwgMTcgKysrKy0tLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3N0YXRpc3Rp Y19leHQuaCAgICAgIHwgIDkgKystLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3N0YXRpc3RpY19l eHRfZGF0YS5oIHwgNTIgKysrKysrKysrKysrKysrKysrKysKc3JjL2luY2x1ZGUvY2F0YWxvZy90 b2FzdGluZy5oICAgICAgICAgICAgICB8ICAxICsKc3JjL2luY2x1ZGUvdXRpbHMvc3lzY2FjaGUu aCAgICAgICAgICAgICAgICB8ICAxICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9vaWRqb2lu cy5vdXQgICAgICB8ICA4ICsrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zYW5pdHlfY2hl Y2sub3V0ICB8ICAxICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdGF0c19leHQub3V0ICAg ICB8IDM4ICsrKysrKysrKystLS0tLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9vaWRqb2lucy5zcWwg ICAgICAgICAgIHwgIDQgKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3RhdHNfZXh0LnNxbCAgICAg ICAgICB8IDMwICsrKysrKysrLS0tLQpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAg ICAgICAgICAgIHwgIDIgKwoyNSBmaWxlcyBjaGFuZ2VkLCAzMzcgaW5zZXJ0aW9ucygrKSwgMTE4 IGRlbGV0aW9ucygtKQoK