[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-committers
Subject:    [COMMITTERS] pgsql: Improve planner to drop constant-NULL inputs of AND/OR where it'
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2014-04-29 17:13:03
Message-ID: E1WfBaZ-0001nm-64 () gemulon ! postgresql ! org
[Download RAW message or body]

SW1wcm92ZSBwbGFubmVyIHRvIGRyb3AgY29uc3RhbnQtTlVMTCBpbnB1dHMg
b2YgQU5EL09SIHdoZXJlIGl0J3MgbGVnYWwuCgpJbiBnZW5lcmFsIHdlIGNh
bid0IGRpc2NhcmQgY29uc3RhbnQtTlVMTCBpbnB1dHMsIHNpbmNlIHRoZXkg
Y291bGQgY2hhbmdlCnRoZSByZXN1bHQgb2YgdGhlIEFORC9PUiB0byBiZSBO
VUxMLiAgQnV0IGF0IHRvcCBsZXZlbCBvZiBXSEVSRSwgd2UgZG8gbm90Cm5l
ZWQgdG8gZGlzdGluZ3Vpc2ggYSBOVUxMIHJlc3VsdCBmcm9tIGEgRkFMU0Ug
cmVzdWx0LCBzbyBpdCdzIG9rYXkgdG8KdHJlYXQgTlVMTCBhcyBGQUxTRSBh
bmQgdGhlbiBzaW1wbGlmeSBBTkQvT1IgYWNjb3JkaW5nbHkuCgpUaGlzIGlz
IGEgdmVyeSBhbmNpZW50IG92ZXJzaWdodCwgYnV0IGluIDkuMiBhbmQgbGF0
ZXIgaXQgY2FuIGxlYWQgdG8KZmFpbHVyZSB0byBvcHRpbWl6ZSBxdWVyaWVz
IHRoYXQgcHJldmlvdXMgcmVsZWFzZXMgZGlkIG9wdGltaXplLCBhcyBhCnJl
c3VsdCBvZiBtb3JlIGFnZ3Jlc3NpdmUgcGFyYW1ldGVyIHN1YnN0aXR1dGlv
biBydWxlcyBtYWtpbmcgaXQgcG9zc2libGUKdG8gcmVkdWNlIG1vcmUgc3Vi
ZXhwcmVzc2lvbnMgdG8gTlVMTCBjb25zdGFudHMuICBUaGlzIGlzIHRoZSBy
b290IGNhdXNlIG9mCmJ1ZyAjMTAxNzEgZnJvbSBBcm5vbGQgU2NoZWZmbGVy
LiAgV2UgY291bGQgYWx0ZXJuYXRpdmVseSBoYXZlIGZpeGVkIHRoYXQKYnkg
dGVhY2hpbmcgb3JjbGF1c2VzLmMgdG8gaWdub3JlIGNvbnN0YW50LU5VTEwg
T1IgYXJtcywgYnV0IGl0IHNlZW1zCmJldHRlciB0byBnZXQgcmlkIG9mIHRo
ZW0gZ2xvYmFsbHkuCgpJIHJlc2lzdGVkIHRoZSB0ZW1wdGF0aW9uIHRvIGJh
Y2stcGF0Y2ggdGhpcyBjaGFuZ2UgaW50byBhbGwgYWN0aXZlCmJyYW5jaGVz
LCBidXQgaXQgc2VlbXMgYXBwcm9wcmlhdGUgdG8gYmFjay1wYXRjaCBhcyBm
YXIgYXMgOS4yIHNvIHRoYXQKdGhlcmUgd2lsbCBub3QgYmUgcGVyZm9ybWFu
Y2UgcmVncmVzc2lvbnMgb2YgdGhlIGtpbmQgc2hvd24gaW4gdGhpcyBidWcu
CgpCcmFuY2gKLS0tLS0tClJFTDlfMl9TVEFCTEUKCkRldGFpbHMKLS0tLS0t
LQpodHRwOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMDkw
MWRiYWIzMzhmMzE2MWI1MGM0YzYwZWY2NjllZDM5M2M5ZTMwOAoKTW9kaWZp
ZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVy
L3ByZXAvcHJlcHF1YWwuYyAgICAgIHwgICA3OSArKysrKysrKysrKysrKysr
KysrKysrKy0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRl
X2luZGV4Lm91dCB8ICAgMTEgKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9j
cmVhdGVfaW5kZXguc3FsICAgICAgfCAgICA3ICsrKwozIGZpbGVzIGNoYW5n
ZWQsIDg1IGluc2VydGlvbnMoKyksIDEyIGRlbGV0aW9ucygtKQoKCi0tIApT
ZW50IHZpYSBwZ3NxbC1jb21taXR0ZXJzIG1haWxpbmcgbGlzdCAocGdzcWwt
Y29tbWl0dGVyc0Bwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRv
IHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3Jn
L21haWxwcmVmL3Bnc3FsLWNvbW1pdHRlcnMK
[prev in list] [next in list] [prev in thread] [next in thread]