{"push_id":3076625660,"size":10,"distinct_size":1,"ref":"refs/heads/commitfest/20/1625","head":"71edfc5af353e34c97b719899660dc8476c92780","before":"e507f645b746ff1c51da3cdd388b1870193a322b","commits":[{"sha":"a80dcac60cdc4b96a296d33288afa74a80f42cca","author":{"name":"Peter Eisentraut","email":"c50e6bf7013fce877ffb25104d778a36de31e297@gmx.net"},"message":"doc: Fix typo","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/a80dcac60cdc4b96a296d33288afa74a80f42cca"},{"sha":"de38ce1b831eef0c1eddcb2d1439f134cd9cd02c","author":{"name":"Alvaro Herrera","email":"3c84f0de6f8a0f296d36cdd9f57fa166641c96b1@alvh.no-ip.org"},"message":"Don't allow partitioned indexes in pg_global tablespace\n\nMissing in dfa608141982.\n\nAuthor: David Rowley\nDiscussion: https://postgr.es/m/CAKJS1f-M3NMTCpv=vDfkoqHbMPFf=3-Z1ud=+1DHH00tC+zLaQ@mail.gmail.com","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/de38ce1b831eef0c1eddcb2d1439f134cd9cd02c"},{"sha":"0f75a466ac41a19214d22de73cceeb5dc792411a","author":{"name":"Tom Lane","email":"ffeaa947aef224da9ba99b6a18bdd74288df0e3e@sss.pgh.pa.us"},"message":"Remove bogus file.","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/0f75a466ac41a19214d22de73cceeb5dc792411a"},{"sha":"3be5fe2b107fae24e03c9d29d7bd7c7ad5345787","author":{"name":"Alvaro Herrera","email":"3c84f0de6f8a0f296d36cdd9f57fa166641c96b1@alvh.no-ip.org"},"message":"Silence compiler warnings\n\nCommit cfdf4dc4fc96 left a few unnecessary assignments, one of which\ncaused compiler warnings, as reported by Erik Rijkers.  Remove them all.\n\nDiscussion: https://postgr.es/m/df0dcca2025b3d90d946ecc508ca9678@xs4all.nl","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/3be5fe2b107fae24e03c9d29d7bd7c7ad5345787"},{"sha":"a314c34079cf06d05265623dd7c056f8fa9d577f","author":{"name":"Tom Lane","email":"ffeaa947aef224da9ba99b6a18bdd74288df0e3e@sss.pgh.pa.us"},"message":"Clamp semijoin selectivity to be not more than inner-join selectivity.\n\nWe should never estimate the output of a semijoin to be more rows than\nwe estimate for an inner join with the same input rels and join condition;\nit's obviously impossible for that to happen.  However, given the\nrelatively poor quality of our semijoin selectivity estimates ---\nparticularly, but not only, in cases where we punt and return a default\nestimate --- we did often deliver such estimates.  To improve matters,\ncalculate both estimates inside eqjoinsel() and take the smaller one.\n\nThe bulk of this patch is just mechanical refactoring to avoid repetitive\ninformation lookup when we call both eqjoinsel_semi and eqjoinsel_inner.\nThe actual new behavior is just\n\n\tselec = Min(selec, inner_rel->rows * selec_inner);\n\nwhich looks a bit odd but is correct because of our different definitions\nfor inner and semi join selectivity.\n\nThere is one ensuing plan change in the regression tests, but it looks\nreasonable enough (and checking the actual row counts shows that the\nestimate moved closer to reality, not further away).\n\nPer bug #15160 from Alexey Ermakov.  Although this is arguably a bug fix,\nI won't risk destabilizing plan choices in stable branches by\nback-patching.\n\nTom Lane, reviewed by Melanie Plageman\n\nDiscussion: https://postgr.es/m/152395805004.19366.3107109716821067806@wrigleys.postgresql.org","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/a314c34079cf06d05265623dd7c056f8fa9d577f"},{"sha":"48c41fa97480756b70ad095fe8d59199df9b12c7","author":{"name":"Tom Lane","email":"ffeaa947aef224da9ba99b6a18bdd74288df0e3e@sss.pgh.pa.us"},"message":"Add a 64-bit hash function for type citext.\n\nAmul Sul, reviewed by Hironobu Suzuki\n\nDiscussion: https://postgr.es/m/CAAJ_b947JjnNr9Cp45iNjSqKf6PA5mCTmKsRwPjows93YwQrmw@mail.gmail.com","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/48c41fa97480756b70ad095fe8d59199df9b12c7"},{"sha":"eb6f29141bed9dc95cb473614c30f470ef980705","author":{"name":"Tom Lane","email":"ffeaa947aef224da9ba99b6a18bdd74288df0e3e@sss.pgh.pa.us"},"message":"Add a 64-bit hash function for type hstore.\n\nThere's some question about the correctness of the hash function, but\nif it's wrong, the 32-bit version is also wrong.\n\nAmul Sul, reviewed by Hironobu Suzuki\n\nDiscussion: https://postgr.es/m/CAAJ_b947JjnNr9Cp45iNjSqKf6PA5mCTmKsRwPjows93YwQrmw@mail.gmail.com","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/eb6f29141bed9dc95cb473614c30f470ef980705"},{"sha":"cbdb8b4c0155b2d9679ecd79b886c29c2730b85d","author":{"name":"Tom Lane","email":"ffeaa947aef224da9ba99b6a18bdd74288df0e3e@sss.pgh.pa.us"},"message":"Fix float-to-integer coercions to handle edge cases correctly.\n\nftoi4 and its sibling coercion functions did their overflow checks in\na way that looked superficially plausible, but actually depended on an\nassumption that the MIN and MAX comparison constants can be represented\nexactly in the float4 or float8 domain.  That fails in ftoi4, ftoi8,\nand dtoi8, resulting in a possibility that values near the MAX limit will\nbe wrongly converted (to negative values) when they need to be rejected.\n\nAlso, because we compared before rounding off the fractional part,\nthe other three functions threw errors for values that really ought\nto get rounded to the min or max integer value.\n\nFix by doing rint() first (requiring an assumption that it handles\nNaN and Inf correctly; but dtoi8 and ftoi8 were assuming that already),\nand by comparing to values that should coerce to float exactly, namely\nINTxx_MIN and -INTxx_MIN.  Also remove some random cosmetic discrepancies\nbetween these six functions.\n\nPer bug #15519 from Victor Petrovykh.  This should get back-patched,\nbut first let's see what the buildfarm thinks of it --- I'm not too\nsure about portability of some of the regression test cases.\n\nPatch by me; thanks to Andrew Gierth for analysis and discussion.\n\nDiscussion: https://postgr.es/m/15519-4fc785b483201ff1@postgresql.org","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/cbdb8b4c0155b2d9679ecd79b886c29c2730b85d"},{"sha":"452b637d4b02e4aa09d45a34d7a048d3f70116bb","author":{"name":"Tom Lane","email":"ffeaa947aef224da9ba99b6a18bdd74288df0e3e@sss.pgh.pa.us"},"message":"Adjust new test case for more portability.\n\nEarly returns from the buildfarm say that most critters are good with\ncommit cbdb8b4c0, but gaur gives unexpected results with the test case\ninvolving a float8 that's one-ULP-less-than-2^63.  It appears that that\nplatform's version of rint() rounds that value up to 2^63 instead of\nleaving it be.  This is possibly a bug, and it's also possible that no\nother platform anybody is using anywhere behaves likewise.  Still, the\npoint of the test is not to insist that everybody's rint() behaves exactly\nthe same.  Let's use two-ULPs-less-than-2^63 instead, which I've tested\nto act the same on gaur as on more modern hardware.\n\n(This is, more or less, exactly the portability issue I'd feared might\narise...)\n\nDiscussion: https://postgr.es/m/15519-4fc785b483201ff1@postgresql.org","distinct":false,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/452b637d4b02e4aa09d45a34d7a048d3f70116bb"},{"sha":"71edfc5af353e34c97b719899660dc8476c92780","author":{"name":"Commitfest Bot","email":"b9e638e07cc2e2abf56c9c0cad7954f2e3bc1641@cputube.org"},"message":"[CF 20/1625] Accounting of zero-filled buffers in EXPLAIN (BUFFERS)\n\nThis commit was automatically generated by cfbot at commitfest.cputube.org.\nIt is based on patches submitted to the PostgreSQL mailing lists and\nregistered in the PostgreSQL Commitfest application.\n\nThis branch will be overwritten each time a new patch version is posted to\nthe email thread, and also periodically to check for bitrot caused by changes\non the master branch.\n\nCommitfest entry: https://commitfest.postgresql.org/20/1625\nPatch(es): https://www.postgresql.org/message-id/CAEepm=3AWXmXg4ZM5iO3_=ZcGw7z-s=JeVpLKnk1svdqzA+bKw@mail.gmail.com\nAuthor(s): Thomas Munro","distinct":true,"url":"https://api.github.com/repos/postgresql-cfbot/postgresql/commits/71edfc5af353e34c97b719899660dc8476c92780"}]}
{"actor":{"display_login":"postgresql-cfbot"}}