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
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 \N 1 1 Don't VACUUM all-frozen pages \N 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 \N 1 1 parallelism, gather node... \N 1 1 Parallel query \N 1 1 Snapshot too old \N 1 1 Snapshot Too Old \N 2 2 bb140506df605fab58f48926ee1db1f80bdafb59 Phrase full text search. 2 1 \\crosstabview \N 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 \N 2 1 LWLock tranches \N 2 1 Parallelism Stuff (many patches) \N 2 1 Parallel Query \N 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 \N 3 1 Default Roles \N 3 1 fd31cd265138019dcccc9b5fe53043670898bc9f Don't vacuum all-frozen pages. 3 1 Parallel aggregate \N 3 1 parallel query \N 3 1 postgres_fdw join push down \N 3 1 Updated backup APIs \N
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
