Re: Postgres 9.6 scariest patch tournament

This is raw, in case anyone wants to look more closely.

alvherre=# select level, count(*), patch, subject from scary left join commits on patch = sha1 group by level, patch, subject order by level asc, count(*) desc;
┌───────┬───────┬───────────────────────────────────────────────────────────────┬────────────────────────────────────────────────────────────────────────────┐
│ level │ count │ patch │ subject │
├───────┼───────┼───────────────────────────────────────────────────────────────┼────────────────────────────────────────────────────────────────────────────┤
│ 1 │ 3 │ fd31cd265138019dcccc9b5fe53043670898bc9f │ Don't vacuum all-frozen pages. │
│ 1 │ 2 │ 3fc6e2d7f5b652b417fa6937c34de2438d60fa9f │ Make the upper part of the planner work by generating and comparing Paths. │
│ 1 │ 1 │ Change the format of the VM fork to add a second bit per page │ │
│ 1 │ 1 │ Don't VACUUM all-frozen pages │ │
│ 1 │ 1 │ 65578341af1ae50e52e0f45e691ce88ad5a1b9b1 │ Add Generic WAL interface │
│ 1 │ 1 │ 9cd00c457e6a1ebb984167ac556a9961812a683c │ Checkpoint sorting and balancing. │
│ 1 │ 1 │ 924bcf4f16d54c55310b28f77686608684734f42 │ Create an infrastructure for parallel computation in PostgreSQL. │
│ 1 │ 1 │ Freeze Map │ │
│ 1 │ 1 │ parallelism, gather node... │ │
│ 1 │ 1 │ Parallel query │ │
│ 1 │ 1 │ Snapshot too old │ │
│ 1 │ 1 │ Snapshot Too Old │ │
│ 2 │ 2 │ bb140506df605fab58f48926ee1db1f80bdafb59 │ Phrase full text search. │
│ 2 │ 1 │ \crosstabview │ │
│ 2 │ 1 │ 1c1a7cbd6a1600c97dfcd9b5dc78a23b5db9bbf6 │ Sync our copy of the timezone library with IANA release tzcode2016c. │
│ 2 │ 1 │ 3fc6e2d7f5b652b417fa6937c34de2438d60fa9f │ Make the upper part of the planner work by generating and comparing Paths. │
│ 2 │ 1 │ 428b1d6b29ca599c5700d4bc4f4ce4c5880369bf │ Allow to trigger kernel writeback after a configurable number of writes. │
│ 2 │ 1 │ 48354581a49c30f5757c203415aa8412d85b0f70 │ Allow Pin/UnpinBuffer to operate in a lockfree manner. │
│ 2 │ 1 │ 848ef42bb8c7909c9d7baa38178d4a209906e7c1 │ Add the "snapshot too old" feature │
│ 2 │ 1 │ fd31cd265138019dcccc9b5fe53043670898bc9f │ Don't vacuum all-frozen pages. │
│ 2 │ 1 │ Freeze map │ │
│ 2 │ 1 │ LWLock tranches │ │
│ 2 │ 1 │ Parallelism Stuff (many patches) │ │
│ 2 │ 1 │ Parallel Query │ │
│ 3 │ 1 │ 013ebc0a7b7ea9c1b1ab7a3d4dd75ea121ea8ba7 │ Microvacuum for GIST │
│ 3 │ 1 │ 0711803775a37e0bf39d7efdd1e34d9d7e640ea1 │ Use quicksort, not replacement selection, for external sorting. │
│ 3 │ 1 │ 45be99f8cd5d606086e0a458c9c72910ba8a613d │ Support parallel joins, and make related improvements. │
│ 3 │ 1 │ 53be0b1add7064ca5db3cd884302dfc3268d884e │ Provide much better wait information in pg_stat_activity. │
│ 3 │ 1 │ 98a64d0bd713cb89e61bef6432befc4b7b5da59e │ Introduce WaitEventSet API. │
│ 3 │ 1 │ Checkpoint sorting & flushin │ │
│ 3 │ 1 │ Default Roles │ │
│ 3 │ 1 │ fd31cd265138019dcccc9b5fe53043670898bc9f │ Don't vacuum all-frozen pages. │
│ 3 │ 1 │ Parallel aggregate │ │
│ 3 │ 1 │ parallel query │ │
│ 3 │ 1 │ postgres_fdw join push down │ │
│ 3 │ 1 │ Updated backup APIs │ │
└───────┴───────┴───────────────────────────────────────────────────────────────┴────────────────────────────────────────────────────────────────────────────┘
(36 filas)

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services