pgsql: Reduce size of backend scanner's tables.
Tom Lane <[email protected]> Mon, 13 Jan 2020 20:04:46 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.cvs |
|---|---|
| Message-ID | <[email protected]> |
--===============7233587844384823338== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVkdWNlIHNpemUgb2YgYmFja2VuZCBzY2FubmVyJ3MgdGFibGVzLgoKUHJldmlvdXNseSwgdGhl IGNvcmUgc2Nhbm5lcidzIHl5X3RyYW5zaXRpb25bXSBhcnJheSBoYWQgMzcwNDUgZWxlbWVudHMu ClNpbmNlIHRoYXQgbnVtYmVyIGlzIGxhcmdlciB0aGFuIElOVDE2X01BWCwgRmxleCBnZW5lcmF0 ZWQgdGhlIGFycmF5IHRvCmNvbnRhaW4gMzItYml0IGludGVnZXJzLiAgQnkgcmVpbXBsZW1lbnRp bmcgc29tZSBvZiB0aGUgYnVsa2llciBzY2FubmVyCnJ1bGVzLCB0aGlzIHBhdGNoIHJlZHVjZXMg dGhlIGFycmF5IHRvIDIwNDk1IGVsZW1lbnRzLiAgVGhlIG11Y2ggc21hbGxlcgp0b3RhbCBsZW5n dGgsIGNvbWJpbmVkIHdpdGggdGhlIGNvbnNlcXVlbnQgdXNlIG9mIDE2LWJpdCBpbnRlZ2VycyBm b3IKdGhlIGFycmF5IGVsZW1lbnRzIHJlZHVjZXMgdGhlIGJpbmFyeSBzaXplIGJ5IG92ZXIgMjAw a0IuICBUaGlzIHdhcwphY2NvbXBsaXNoZWQgaW4gdHdvIHdheXM6CgoxLiBDb25zb2xpZGF0ZSBo YW5kbGluZyBvZiBxdW90ZSBjb250aW51YXRpb25zIGludG8gYSBuZXcgc3RhcnQgY29uZGl0aW9u LApyYXRoZXIgdGhhbiBkdXBsaWNhdGluZyB0aGF0IGxvZ2ljIGZvciBmaXZlIGRpZmZlcmVudCBz dHJpbmcgdHlwZXMuCgoyLiBUcmVhdCBVbmljb2RlIHN0cmluZ3MgYW5kIGlkZW50aWZpZXJzIGZv bGxvd2VkIGJ5IGEgVUVTQ0FQRSBzZXF1ZW5jZQphcyB0aHJlZSBzZXBhcmF0ZSB0b2tlbnMsIHJh dGhlciB0aGFuIG9uZS4gIFRoZSBsb2dpYyB0byBkZS1lc2NhcGUKVW5pY29kZSBzdHJpbmdzIGlz IG1vdmVkIHRvIHRoZSBmaWx0ZXIgY29kZSBpbiBwYXJzZXIuYywgd2hpY2ggYWxyZWFkeQpoYWQg dGhlIGFiaWxpdHkgdG8gcHJvdmlkZSBzcGVjaWFsIHByb2Nlc3NpbmcgZm9yIHRva2VuIHNlcXVl bmNlcy4KV2hpbGUgd2UgY291bGQgaGF2ZSBpbXBsZW1lbnRlZCB0aGUgY29udmVyc2lvbiBpbiB0 aGUgZ3JhbW1hciwgdGhhdAphcHByb2FjaCB3YXMgcmVqZWN0ZWQgZm9yIHBlcmZvcm1hbmNlIGFu ZCBtYWludGFpbmFiaWxpdHkgcmVhc29ucy4KClBlcmZvcm1hbmNlIGluIG1pY3JvYmVuY2htYXJr cyBvZiByYXcgcGFyc2luZyBzZWVtcyBlcXVhbCBvciBzbGlnaHRseQpmYXN0ZXIgaW4gbW9zdCBj YXNlcywgYW5kIGl0J3MgcmVhc29uYWJsZSB0byBleHBlY3QgdGhhdCBpbiByZWFsLXdvcmxkCnVz YWdlICh3aXRoIG1vcmUgY29tcGV0aXRpb24gZm9yIHRoZSBDUFUgY2FjaGUpIHRoZXJlIHdpbGwg YmUgYSBsYXJnZXIKd2luLiAgVGhlIGV4Y2VwdGlvbiBpcyBVRVNDQVBFIHNlcXVlbmNlczsgbGV4 aW5nIHRob3NlIGlzIGFib3V0IDEwJQpzbG93ZXIsIHByaW1hcmlseSBiZWNhdXNlIHRoZSBzY2Fu bmVyIG5vdyBoYXMgdG8gYmUgY2FsbGVkIHRocmVlIHRpbWVzCnJhdGhlciB0aGFuIG9uZS4gIFRo aXMgc2VlbXMgYWNjZXB0YWJsZSBzaW5jZSB0aGF0IGZlYXR1cmUgaXMgdmVyeQpyYXJlbHkgdXNl ZC4KClRoZSBwc3FsIGFuZCBlcGNnIGxleGVycyBhcmUgbGlrZXdpc2UgbW9kaWZpZWQsIHByaW1h cmlseSBiZWNhdXNlIHdlCndhbnQgdG8ga2VlcCB0aGVtIGFsbCBpbiBzeW5jLiAgU2luY2UgdGhv c2UgbGV4ZXJzIGRvbid0IHVzZSB0aGUKc3BhY2UtaG9nZ2luZyAtQ0Ygb3B0aW9uLCB0aGUgc3Bh Y2Ugc2F2aW5ncyBpcyBtdWNoIGxlc3MsIGJ1dCBpdCdzCnN0aWxsIGdvb2QgZm9yIHBlcmhhcHMg MTBrQiBhcGllY2UuCgpXaGlsZSBhdCBpdCwgbWVyZ2UgdGhlIGVjcGcgbGV4ZXIncyBoYW5kbGlu ZyBvZiBDLXN0eWxlIGNvbW1lbnRzIHVzZWQKaW4gU1FMIGFuZCBpbiBDLiAgVGhvc2UgaGF2ZSBk aWZmZXJlbnQgcnVsZXMgcmVnYXJkaW5nIG5lc3RlZCBjb21tZW50cywKYnV0IHNpbmNlIHdlIGFs cmVhZHkgaGF2ZSB0aGUgYWJpbGl0eSB0byBrZWVwIHRyYWNrIG9mIHRoZSBwcmV2aW91cwpzdGFy dCBjb25kaXRpb24sIHdlIGNhbiB1c2UgdGhhdCB0byBoYW5kbGUgYm90aCBjYXNlcyB3aXRoaW4g YSBzaW5nbGUKc3RhcnQgY29uZGl0aW9uLiAgVGhpcyBtYXRjaGVzIHRoZSBjb3JlIHNjYW5uZXIg bW9yZSBjbG9zZWx5LgoKSm9obiBOYXlsb3IKCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vQ0FDUE5aQ3Zhb2EzRWdWV201eVpoY1NUWDZSQXRhTGduaUNQY0JWT0N3bThoM3hwV2t3QG1h aWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvN2YzODBjNTlmODAwZjdlMGZiNDlm NDVhNmZmNzc4NzI1Njg1MWE1OQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTAgKy0Kc3Jj L2JhY2tlbmQvcGFyc2VyL3BhcnNlci5jICAgICAgICAgICAgICAgICAgICAgICAgfCAyODIgKysr KysrKysrKysrKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3NjYW4ubCAgICAgICAgICAgICAgICAgICAg ICAgICAgfCA0MTQgKysrKy0tLS0tLS0tLS0tLS0tLS0tCnNyYy9mZV91dGlscy9wc3Fsc2Nhbi5s ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgMTI0ICsrKy0tLQpzcmMvaW5jbHVkZS9mZV91 dGlscy9wc3Fsc2Nhbl9pbnQuaCAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL21i L3BnX3djaGFyLmggICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDIyICsrCnNyYy9pbmNsdWRl L3BhcnNlci9rd2xpc3QuaCAgICAgICAgICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1 ZGUvcGFyc2VyL3NjYW5uZXIuaCAgICAgICAgICAgICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL2lu dGVyZmFjZXMvZWNwZy9wcmVwcm9jL2VjcGcudG9rZW5zICAgICAgICAgICAgfCAgIDEgLQpzcmMv aW50ZXJmYWNlcy9lY3BnL3ByZXByb2MvZWNwZy50cmFpbGVyICAgICAgICAgICB8ICAzOCArLQpz cmMvaW50ZXJmYWNlcy9lY3BnL3ByZXByb2MvZWNwZy50eXBlICAgICAgICAgICAgICB8ICAgNiAr LQpzcmMvaW50ZXJmYWNlcy9lY3BnL3ByZXByb2MvcGFyc2UucGwgICAgICAgICAgICAgICB8ICAg NCArLQpzcmMvaW50ZXJmYWNlcy9lY3BnL3ByZXByb2MvcGFyc2VyLmMgICAgICAgICAgICAgICB8 IDExOCArKysrLS0Kc3JjL2ludGVyZmFjZXMvZWNwZy9wcmVwcm9jL3BnYy5sICAgICAgICAgICAg ICAgICAgfCAyNDcgKysrKysrLS0tLS0tCi4uLi9lY3BnL3Rlc3QvZXhwZWN0ZWQvcHJlcHJvYy1z dHJpbmdzLmMgICAgICAgICAgIHwgICAyICstCi4uLi9lY3BnL3Rlc3QvZXhwZWN0ZWQvcHJlcHJv Yy1zdHJpbmdzLnN0ZGVyciAgICAgIHwgICAyICstCnNyYy9wbC9wbHBnc3FsL3NyYy9wbF9ncmFt LnkgICAgICAgICAgICAgICAgICAgICAgIHwgICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvc3RyaW5ncy5vdXQgICAgICAgICAgICAgIHwgIDEyICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L3N0cmluZ3Muc3FsICAgICAgICAgICAgICAgICAgIHwgICAxICsKMTkgZmlsZXMgY2hhbmdlZCwg NjcxIGluc2VydGlvbnMoKyksIDYxOSBkZWxldGlvbnMoLSkKCg== --===============7233587844384823338==--