Postgres Pro
Downloads
Home   >   mailing lists

BUG #14404: High row estimates when query uses master inherited tables - Mailing list pgsql-bugs

From clinton.adams@gmail.com
Subject BUG #14404: High row estimates when query uses master inherited tables
Date
Msg-id 20161028200412.15987.96482@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14404: High row estimates when query uses master inherited tables
List pgsql-bugs
Tree view 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQwNApMb2dnZWQgYnk6ICAg
ICAgICAgIENsaW50b24gQWRhbXMKRW1haWwgYWRkcmVzczogICAgICBjbGlu
dG9uLmFkYW1zQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNi4x
Ck9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zIDcsIDQuMy4wLTEuZWw3LmVs
cmVwby54ODZfNjQgIzEgU01QIFR1ZSBOb3YKRGVzY3JpcHRpb246ICAgICAg
ICAKClJvdyBlc3RpbWF0ZXMgYXJlIHdheSBvZmYgKDQwNjQ4NDA1NDY3ODYz
MSB2cyAzOCkgd2hlbiB1c2luZyBtYXN0ZXIKcGFydGl0aW9uIHRhYmxlcy4g
SWYgSSBjaGFuZ2UgdGhlIHF1ZXJ5IHRvIGdvIGRpcmVjdGx5IGFnYWluc3Qg
b25lIGNoaWxkCnRhYmxlLCBlc3RpbWF0ZXMgYW5kIHF1ZXJ5IHRpbWUgYXJl
IGluIGxpbmUgd2l0aCB3aGF0IEkgZXhwZWN0Lg0KDQpJc3N1ZSBvY2N1cnMg
b24gOS42LjEsIGFsbCB0YWJsZXMgYW5hbHl6ZWQuIFJvdyBjb3VudHMgcGVy
IGNoaWxkIHRhYmxlCihzZW5zb3Jjb3JlOCwgY29yZWRldGFpbDgsIGV0Yykg
YXJlIDEyNjM0MDU4OCBlYWNoLg0KDQpJc3N1ZSBkb2VzIG5vdCBvY2N1ciBv
biA5LjQuNiAoZG8gbm90IGhhdmUgOS41IGhhbmR5IHRvIHRlc3QgYXRtKS4N
Cg0KLS0NCi0tIFBsYW4gd2l0aCBoaWdoIGVzdGltYXRlDQotLQ0KRVhQTEFJ
Tg0KU0VMRUNUIGNvcmUuc2Vuc29yY29yZWlkDQogICBGUk9NIHNlbnNvci5z
ZW5zb3Jjb3JlIGNvcmUgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K
ICAgICBKT0lOIHNlbnNvci5jb3JlZGV0YWlsIGNvcmVkIE9OIGNvcmVkLnR5
cGVpZCA9IGNvcmUudHlwZWlkIEFORApjb3JlZC5zZW5zb3Jjb3JlaWQgPSBj
b3JlLnNlbnNvcmNvcmVpZA0KICAgICBKT0lOIHNlbnNvci5jb3JlZmlsbGRl
dGFpbCBjb3JlZmQgT04gY29yZWZkLnR5cGVpZCA9IGNvcmUudHlwZWlkIEFO
RApjb3JlZmQuc2Vuc29yY29yZWlkID0gY29yZS5zZW5zb3Jjb3JlaWQNCiAg
V0hFUkUNCmNvcmUudHlwZWlkID0gOCBBTkQgY29yZS5zZW5zb3JpZCA9IDE4
MTQ4MjE7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgCiAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LQ0KIE1lcmdlIEpvaW4gIChjb3N0PTUuNjIuLjU3MTc1MDA4LjM3IHJvd3M9
NDA2NDg0MDU0Njc4NjMxIHdpZHRoPTQpDQogICBNZXJnZSBDb25kOiAoY29y
ZWZkLnNlbnNvcmNvcmVpZCA9IGNvcmVkLnNlbnNvcmNvcmVpZCkNCiAgIC0+
ICBNZXJnZSBBcHBlbmQgIChjb3N0PTIuODEuLjI4MjY4OTUzLjkxIHJvd3M9
MTI2MzQwNTkzIHdpZHRoPTgpDQogICAgICAgICBTb3J0IEtleTogY29yZWZk
LnNlbnNvcmNvcmVpZA0KICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcg
aXhfY29yZWZpbGxkZXRhaWwgb24gY29yZWZpbGxkZXRhaWwgY29yZWZkIAoo
Y29zdD0wLjUwLi4zLjU5IHJvd3M9MSB3aWR0aD04KQ0KICAgICAgICAgICAg
ICAgRmlsdGVyOiAodHlwZWlkID0gOCkNCiAgICAgICAgIC0+ICBJbmRleCBT
Y2FuIHVzaW5nIGl4X2NvcmVmaWxsZGV0YWlsOCBvbiBjb3JlZmlsbGRldGFp
bDggY29yZWZkXzEKIChjb3N0PTIuMjcuLjIxOTUxOTIwLjYzIHJvd3M9MTI2
MzQwNTkyIHdpZHRoPTgpDQogICAgICAgICAgICAgICBGaWx0ZXI6ICh0eXBl
aWQgPSA4KQ0KICAgLT4gIE1hdGVyaWFsaXplICAoY29zdD0yLjgxLi4xNjM0
OTY5MC4zNiByb3dzPTEyNTQ3NzMxMyB3aWR0aD0xMikNCiAgICAgICAgIC0+
ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9Mi44MS4uMTUwOTQ5MTcuMjMgcm93cz0x
MjU0NzczMTMgd2lkdGg9MTIpDQogICAgICAgICAgICAgICAtPiAgTWVyZ2Ug
QXBwZW5kICAoY29zdD0yLjgxLi4xNTA5NDcwMS4zNiByb3dzPTM5IHdpZHRo
PTgpDQogICAgICAgICAgICAgICAgICAgICBTb3J0IEtleTogY29yZS5zZW5z
b3Jjb3JlaWQNCiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2Fu
IHVzaW5nIHBrX3NlbnNvcmNvcmUgb24gc2Vuc29yY29yZSBjb3JlIAooY29z
dD0wLjUwLi4zLjYwIHJvd3M9MSB3aWR0aD04KQ0KICAgICAgICAgICAgICAg
ICAgICAgICAgICAgRmlsdGVyOiAoKHR5cGVpZCA9IDgpIEFORCAoc2Vuc29y
aWQgPSAxODE0ODIxKSkNCiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRl
eCBTY2FuIHVzaW5nIHNlbnNvcl9zZW5zb3Jjb3JlOF9wa2V5IG9uCnNlbnNv
cmNvcmU4IGNvcmVfMSAgKGNvc3Q9Mi4yNy4uMTUwOTQ2OTUuNzcgcm93cz0z
OCB3aWR0aD04KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVy
OiAoKHR5cGVpZCA9IDgpIEFORCAoc2Vuc29yaWQgPSAxODE0ODIxKSkNCiAg
ICAgICAgICAgICAgIC0+ICBBcHBlbmQgIChjb3N0PTAuMDAuLjUuMzggcm93
cz0yIHdpZHRoPTgpDQogICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNj
YW4gb24gY29yZWRldGFpbCBjb3JlZCAgKGNvc3Q9MC4wMC4uMC4wMApyb3dz
PTEgd2lkdGg9OCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRl
cjogKCh0eXBlaWQgPSA4KSBBTkQgKGNvcmUuc2Vuc29yY29yZWlkID0Kc2Vu
c29yY29yZWlkKSkNCiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBT
Y2FuIHVzaW5nIGl4X2NvcmVkZXRhaWw4IG9uIGNvcmVkZXRhaWw4CmNvcmVk
XzEgIChjb3N0PTIuMjcuLjUuMzggcm93cz0xIHdpZHRoPTgpDQogICAgICAg
ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoc2Vuc29yY29yZWlk
ID0gY29yZS5zZW5zb3Jjb3JlaWQpDQogICAgICAgICAgICAgICAgICAgICAg
ICAgICBGaWx0ZXI6ICh0eXBlaWQgPSA4KQ0KDQoNCi0tDQotLSBQbGFuIHVz
aW5nIGNoaWxkIHBhcnRpdGlvbg0KLS0NCkVYUExBSU4NClNFTEVDVCBjb3Jl
LnNlbnNvcmNvcmVpZA0KICAgRlJPTSBzZW5zb3Iuc2Vuc29yY29yZTggY29y
ZQ0KICAgICBKT0lOIHNlbnNvci5jb3JlZGV0YWlsIGNvcmVkIE9OIGNvcmVk
LnR5cGVpZCA9IGNvcmUudHlwZWlkIEFORApjb3JlZC5zZW5zb3Jjb3JlaWQg
PSBjb3JlLnNlbnNvcmNvcmVpZA0KICAgICBKT0lOIHNlbnNvci5jb3JlZmls
bGRldGFpbCBjb3JlZmQgT04gY29yZWZkLnR5cGVpZCA9IGNvcmUudHlwZWlk
IEFORApjb3JlZmQuc2Vuc29yY29yZWlkID0gY29yZS5zZW5zb3Jjb3JlaWQN
CiAgV0hFUkUNCmNvcmUudHlwZWlkID0gOCBBTkQgY29yZS5zZW5zb3JpZCA9
IDE4MTQ4MjE7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOCiAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBOZXN0ZWQgTG9vcCAgKGNv
c3Q9Mi4yNy4uNDE1LjU4IHJvd3M9Mzggd2lkdGg9NCkNCiAgIEpvaW4gRmls
dGVyOiAoY29yZS5zZW5zb3Jjb3JlaWQgPSBjb3JlZC5zZW5zb3Jjb3JlaWQp
DQogICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTIuMjcuLjIyNy4wMyByb3dz
PTM4IHdpZHRoPTEyKQ0KICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcg
aXhfc2Vuc29yY29yZTggb24gc2Vuc29yY29yZTggY29yZSAKKGNvc3Q9Mi4y
Ny4uNTQuMjAgcm93cz0zOCB3aWR0aD04KQ0KICAgICAgICAgICAgICAgSW5k
ZXggQ29uZDogKHNlbnNvcmlkID0gMTgxNDgyMSkNCiAgICAgICAgICAgICAg
IEZpbHRlcjogKHR5cGVpZCA9IDgpDQogICAgICAgICAtPiAgQXBwZW5kICAo
Y29zdD0wLjAwLi40LjM5IHJvd3M9MiB3aWR0aD04KQ0KICAgICAgICAgICAg
ICAgLT4gIFNlcSBTY2FuIG9uIGNvcmVmaWxsZGV0YWlsIGNvcmVmZCAgKGNv
c3Q9MC4wMC4uMC4wMApyb3dzPTEgd2lkdGg9OCkNCiAgICAgICAgICAgICAg
ICAgICAgIEZpbHRlcjogKCh0eXBlaWQgPSA4KSBBTkQgKGNvcmUuc2Vuc29y
Y29yZWlkID0Kc2Vuc29yY29yZWlkKSkNCiAgICAgICAgICAgICAgIC0+ICBJ
bmRleCBPbmx5IFNjYW4gdXNpbmcKY29yZWZpbGxkZXRhaWw4X3R5cGVpZF9z
ZW5zb3Jjb3JlaWRfaWR4IG9uIGNvcmVmaWxsZGV0YWlsOCBjb3JlZmRfMSAK
KGNvc3Q9Mi4yNy4uNC4zOSByb3dzPTEgd2lkdGg9OCkNCiAgICAgICAgICAg
ICAgICAgICAgIEluZGV4IENvbmQ6ICgodHlwZWlkID0gOCkgQU5EIChzZW5z
b3Jjb3JlaWQgPQpjb3JlLnNlbnNvcmNvcmVpZCkpDQogICAtPiAgQXBwZW5k
ICAoY29zdD0wLjAwLi40Ljc4IHJvd3M9MiB3aWR0aD04KQ0KICAgICAgICAg
LT4gIFNlcSBTY2FuIG9uIGNvcmVkZXRhaWwgY29yZWQgIChjb3N0PTAuMDAu
LjAuMDAgcm93cz0xCndpZHRoPTgpDQogICAgICAgICAgICAgICBGaWx0ZXI6
ICgodHlwZWlkID0gOCkgQU5EIChjb3JlZmQuc2Vuc29yY29yZWlkID0Kc2Vu
c29yY29yZWlkKSkNCiAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGl4
X2NvcmVkZXRhaWw4IG9uIGNvcmVkZXRhaWw4IGNvcmVkXzEgCihjb3N0PTIu
MjcuLjQuNzggcm93cz0xIHdpZHRoPTgpDQogICAgICAgICAgICAgICBJbmRl
eCBDb25kOiAoc2Vuc29yY29yZWlkID0gY29yZWZkLnNlbnNvcmNvcmVpZCkN
CiAgICAgICAgICAgICAgIEZpbHRlcjogKHR5cGVpZCA9IDgpDQoKCg==

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14403: Large numbers of CREATE OR UPDATE function causes memory exhaustion
Next
From: Tom Lane
Date:
Subject: Re: BUG #14404: High row estimates when query uses master inherited tables