Re: Postgres 9.6 scariest patch tournament - Mailing list pgsql-hackers

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,
subjectorder 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
workby 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
computationin 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
withIANA release tzcode2016c.       │ 
│     2 │     1 │ 3fc6e2d7f5b652b417fa6937c34de2438d60fa9f                      │ Make the upper part of the planner
workby generating and comparing Paths. │ 
│     2 │     1 │ 428b1d6b29ca599c5700d4bc4f4ce4c5880369bf                      │ Allow to trigger kernel writeback
aftera configurable number of writes.   │ 
│     2 │     1 │ 48354581a49c30f5757c203415aa8412d85b0f70                      │ Allow Pin/UnpinBuffer to operate in a
lockfreemanner.                     │ 
│     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
relatedimprovements.                     │ 
│     3 │     1 │ 53be0b1add7064ca5db3cd884302dfc3268d884e                      │ Provide much better wait information
inpg_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