On 3/1/18 4:52 AM, Magnus Hagander wrote:
>
> The remaining 45 are, ordered by time created:
OK, here's my break down after a brief review of all the patches in the
list. Many of the patches were trivial/small, bug fixes, had history,
or related to builds, tests, or docs.
There are still 13 patches that are medium/large (in terms of impact,
not size) from my analysis, and new.
Medium/Large and New:
Verify Checksums during Basebackups
CALL optional in PL/pgSQL
chained transactions
INOUT parameters in procedures
SET TRANSACTION in PL/pgSQL
PL/pgSQL nested CALL with transactions
committing inside cursor loop
ON CONFLICT DO UPDATE for partitioned tables
handling of heap rewrites in logical decoding
Changing the autovacuum launcher scheduling; oldest table first algorithm
Let's remove DSM_INPL_NONE?
[PROPOSAL] Nepali Snowball dictionary?
Opclass parameters (recommend RWF or push by me)
Parallel Dump to /dev/null (recommend push by Andres)
Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist
(already moved to next CF by me)
This one is large, has history, but had been idle for a long time:
kNN for SP-GiST (last submitted for 2017-03 CF, RWF, then idle for one
year until this CF)
Was already rejected:
Direct converting numeric types to bool
The following patches seem OK to me, but I'm happy for feedback. Note
that one of the small patches is mine -- I think it's small because it
shares a lot of code with a patch that is already marked RFC, but I
won't object if the consensus is to push it.
Trivial / Build / Tests / Docs:
Unlogged tables re-initialization tests
Comment of formdesc() forgets pg_subscription
Minor clean-up in dshash.{c,h}
Align isolation tester output
Updating parallel.sgml's treatment of parallel joins
symlink installs
Bugs:
Fix "unsupported type" with custom numeric types in convert_to_scalar
Standby cannot catch up primary after pg_rewind
line_perp() (?-|) is broken.
Correctly inhibit indexonly when multiple occurrence of an index column
ActivePerl 5.24.3 breaks PG compilation in Windows
ConvertRowtypeExpr reference errors from partition-wise join
Incorrect flag passed to initial_cost_hashjoin()
fixing more format truncation issues (this is under refactoring but
reads a bit more like bugs fixes to me)
Active history and review, just newly added to CF:
Cast jsonb to numeric, int, float, bool
Predicate locking in gin index
JIT compiling expressions & tuple deforming
Transactions involving multiple postgres foreign servers
Advanced partition matching for partition-wise join
Minor clean-up in dshash.{c,h}
Small and New:
Nested ConvertRowtypeExpr optimization
Reopen logfile on SIGHUP
Function to track shmem reinit time
Removing shm_mq.c's volatile qualifiers
Exclude temp relations from base backup (This is my patch so I prefer
somebody else decide its fate)
remove pg_class.relhaspkey
Ready for Committer:
pg_proc.prokind column
Increase initdb's fallback value of max_connection to 20
Feedback?
Thanks,
--
-David
da...@pgmasters.net
