== PostgreSQL Weekly News - June 10 2018 ==
От | David Fetter |
---|---|
Тема | == PostgreSQL Weekly News - June 10 2018 == |
Дата | |
Msg-id | 20180610222835.GA6035@fetter.org обсуждение исходный текст |
Список | pgsql-announce |
== PostgreSQL Weekly News - June 10 2018 == == PostgreSQL Product News == PGConf.ASIA 2018 will take place on December 10-12, 2018 in Akihabara, Tokyo, Japan. The CfP is open until midnight, July 31, 2018, Japan time at pgconf-asia-2018-submission(at)pgconf(dot)asia http://www.pgconf.asia/EN/2018/ 2Q PGConf will be on December 4-5, 2018 in Chicago, IL. The CfP is open through August 27, 2018 at midnight Pacific Time at http://www.2qpgconf.com/#cfp http://www.2qpgconf.com/ == PostgreSQL Jobs for June == http://archives.postgresql.org/pgsql-jobs/2018-06/ == PostgreSQL Local == PGDay.IT 2018 will take place in Lazise on Lake Garda on June 29, 2018. https://2018.pgday.it/en/ Swiss PGDay 2018 will take place in Rapperswil (near Zurich) on June 29, 2018. Registration is open through June 28, 2018. http://www.pgday.ch/2018/ PGConf.Brazil 2018 will take place in São Paulo, Brazil on August 3-4 2018. http://pgconf.com.br PG Day France 2018 will take place in Marseille on June 26, 2018. http://pgday.fr/ The Portland PostgreSQL Users Group will be holding a PGDay on September 10, 2018 in Portland, OR. The CfP is open at https://goo.gl/forms/E0CiUQGSZGMYwh922 https://pdx.postgresql.us/pdxpgday2018 PgConf Silicon Valley 2018 will be held in San Francisco on September 5-7, 2018. The CfP is open until June 12th, Anywhere on Earth (AoE) (2018-06-12 23:59:59-12:00) https://2018.postgresopen.org/callforpapers/ PostgresConf South Africa 2018 will take place in Johannesburg on October 9, 2018 The Call for Papers is open through June 30, 2018. https://postgresconf.org/conferences/SouthAfrica2018 == PostgreSQL in the News == Planet PostgreSQL: http://planet.postgresql.org/ PostgreSQL Weekly News is brought to you this week by David Fetter Submit news and announcements by Sunday at 3:00pm PST8PDT. Please send English language ones to david@fetter.org, German language to pwn@pgug.de, Italian language to pwn@itpug.org. == Applied Patches == Peter Eisentraut pushed: - Put new command-line options into alphabetical order. https://git.postgresql.org/pg/commitdiff/4d6a854f176dbb48e62f017d8234f4736cb48d24 - Fix typo. https://git.postgresql.org/pg/commitdiff/2241ad1556b3734b4867117bee8d78ef9577fceb - Fix spurious non-ASCII bytes. https://git.postgresql.org/pg/commitdiff/3f85c62d9e825eedd1315d249ef1ad793ca78ed4 - Add missing serial commas. https://git.postgresql.org/pg/commitdiff/25cf4ed1dc4e16da042e73ef5090e54bcf271f45 - doc: Move some new options into better positions on man pages. https://git.postgresql.org/pg/commitdiff/5efbdd36f1584d5e6e3870a05dc5f53692b18df6 - ecpg: Document new compatibility option. It's listed in --help, so it should be listed in the man page as well. https://git.postgresql.org/pg/commitdiff/3b9b7516f42b72589951bb8d47a0220c67fb70de - Fix typo. https://git.postgresql.org/pg/commitdiff/acad8b409add4bde37e3882c1680a7bd26289f03 Álvaro Herrera pushed: - Fix function code in error report. This bug causes a lseek() failure to be reported as a "could not open" failure in the error message, muddling bug reports. I introduced this copy-and-pasteo in commit 78e122010422. Noticed while reviewing code for bug report #15221, from lily liang. In version 10 the affected function is only used by multixact.c and commit_ts, and only in corner-case circumstances, neither of which are involved in the reported bug (a pg_subtrans failure.) Author: Álvaro Herrera https://git.postgresql.org/pg/commitdiff/eee381ef5ec4b16cff37865ccd70510e1e1abcdc - Teach SHOW ALL to honor pg_read_all_settings membership. Also, fix the pg_settings view to display source filename and line number when invoked by a pg_read_all_settings member. This addition by me (Álvaro). Also, fix wording of the comment in GetConfigOption regarding the restriction it implements, renaming the parameter for extra clarity. Noted by Michaël. These were all oversight in commit 25fff40798fc; backpatch to pg10, where that commit first appeared. Author: Laurenz Albe Reviewed-by: Michaël Paquier, Álvaro Herrera Discussion: https://postgr.es/m/1519917758.6586.8.camel@cybertec.at https://git.postgresql.org/pg/commitdiff/0c8910a0cab7c1e439bf5f5850122c36359e6799 Heikki Linnakangas pushed: - Fix obsolete comment. The 'orig_slot' argument was removed in commit c0a8ae7be392, but that commit forgot to update the comment. Author: Amit Langote Discussion: https://www.postgresql.org/message-id/194ac4bf-7b4a-c887-bf26-bc1a85ea995a@lab.ntt.co.jp https://git.postgresql.org/pg/commitdiff/57f06a7611cc4806f581ae838f145181164056d4 Magnus Hagander pushed: - Fix typo in README. Author: Daniel Gustafsson <daniel@yesql.se> https://git.postgresql.org/pg/commitdiff/848b1f3e358f4a1bb98d8c4a07ff8ee5fd7ea9a0 Simon Riggs pushed: - Exclude VACUUMs from RunningXactData. GetRunningTransactionData() should ignore VACUUM procs because in some cases they are assigned xids. This could lead to holding back xmin via the route of passing the xid to standby and then having that hold back xmin on master via feedback. Backpatch to 9.1 needed, but will only do so on supported versions. Backpatch once proven on the buildfarm. Reported-by: Greg Stark Author: Simon Riggs Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CANP8+jJBYt=4PpTfiPb0UrH1_iPhzsxKH5Op_Wec634F0ohnAw@mail.gmail.com https://git.postgresql.org/pg/commitdiff/32ac7a118fc17f5baac1b370f50d759c30bee00a Peter Geoghegan pushed: - Fix typo in JIT README. Author: Daniel Gustafsson Discussion: https://postgr.es/m/3747D478-41F9-439F-8074-AC81A5C76346@yesql.se https://git.postgresql.org/pg/commitdiff/f6b95ff434bff28c0d9b390d5a0ff316847c4fb7 Thomas Munro pushed: - Limit Parallel Hash's bucket array to MaxAllocSize. Make sure that we don't exceed MaxAllocSize when increasing the number of buckets. Perhaps later we'll remove that limit and use DSA_ALLOC_HUGE, but for now just prevent further increases like the non-parallel code. This change avoids the error from bug report #15225. Author: Thomas Munro Reviewed-By: Tom Lane Reported-by: Frits Jalvingh Discussion: https://postgr.es/m/152802081668.26724.16985037679312485972%40wrigleys.postgresql.org https://git.postgresql.org/pg/commitdiff/86a2218eb00eb6f97898945967c5f9c95c72b4c6 Michaël Paquier pushed: - Fix and document lock handling for in-memory replication slot data. While debugging issues on HEAD for the new slot forwarding feature of Postgres 11, some monitoring of the code surrounding in-memory slot data has proved that the lock handling may cause inconsistent data to be read by read-only callers of slot functions, particularly pg_get_replication_slots() which fetches data for the system view pg_replication_slots, or modules looking directly at slot information. The code paths involved in those problems concern logical decoding initialization (down to 9.4) and WAL reservation for slots (new as of 10). A set of comments documenting all the lock handlings, particularly the dependency with LW locks for slots and the in_use flag as well as the internal mutex lock is added, based on a suggested by Simon Riggs. Some of the fixed code exists down to 9.4 where WAL decoding has been introduced, but as those race conditions are really unlikely going to happen as those concern code paths for slot and decoding creation, just fix the problem on HEAD. Author: Michael Paquier Discussion: https://postgr.es/m/20180528085747.GA27845@paquier.xyz https://git.postgresql.org/pg/commitdiff/9e149c847f398793ec1641885434dcd10837d89d - Fix grammar in REVOKE documentation. Reported-by: Erwin Brandstetter https://git.postgresql.org/pg/commitdiff/c83e2029909c5411ca11fd841851016f1f9810e6 Tom Lane pushed: - Improve run-time partition pruning to handle any stable expression. The initial coding of the run-time-pruning feature only coped with cases where the partition key(s) are compared to Params. That is a bit silly; we can allow it to work with any non-Var-containing stable expression, as long as we take special care with expressions containing PARAM_EXEC Params. The code is hardly any longer this way, and it's considerably clearer (IMO at least). Per gripe from Pavel Stehule. David Rowley, whacked around a bit by me Discussion: https://postgr.es/m/CAFj8pRBjrufA3ocDm8o4LPGNye9Y+pm1b9kCwode4X04CULG3g@mail.gmail.com https://git.postgresql.org/pg/commitdiff/73b7f48f78d27b1baf1a6541cbaae0fe6bd6186d - Relocate partition pruning structs to a saner place. These struct definitions were originally dropped into primnodes.h, which is a poor choice since that's mainly intended for primitive expression node types; these are not in that category. What they are is auxiliary info in Plan trees, so move them to plannodes.h. For consistency, also relocate some related code that was apparently placed with the aid of a dartboard. There's no interesting code changes in this commit, just reshuffling. David Rowley and Tom Lane Discussion: https://postgr.es/m/CAFj8pRBjrufA3ocDm8o4LPGNye9Y+pm1b9kCwode4X04CULG3g@mail.gmail.com https://git.postgresql.org/pg/commitdiff/939449de0e571b8c0b07674bb7095e06e93cc059 - Assorted cosmetic cleanup of run-time-partition-pruning code. Use "subplan" rather than "subnode" to refer to the child plans of a partitioning Append; this seems a bit more specific and hence clearer. Improve assorted comments. No non-cosmetic changes. David Rowley and Tom Lane Discussion: https://postgr.es/m/CAFj8pRBjrufA3ocDm8o4LPGNye9Y+pm1b9kCwode4X04CULG3g@mail.gmail.com https://git.postgresql.org/pg/commitdiff/321f648a312bd188b7a5c33a0548a57f45dfbf42 == Pending Patches == Fujii Masao sent in a patch to fix the performance of DROP DATABASE with many tablespaces in it by ensuring that DROP DATABASE generates only one XLOG_DBASE_DROP record, and registers the information of all the tablespaces into it. Kyotaro HORIGUCHI sent in three more revisions of a patch to fix a problem while updating a foreign table pointing to a partitioned table on foreign server. Heikki Linnakangas sent in a patch to optimize memory usage in SetOp executor node and allow SetOps to spill to storage. Justin Pryzby sent in two more revisions of a patch to add tab completion in psql for table partitions. Jeff Janes sent in a patch to make deparsing of column defaults faster. Alexander Korotkov sent in a patch to lock B-tree leaves immediately in exclusive mode. Peter Eisentraut sent in a patch to use $Test::Builder::Level in TAP test functions. Andres Freund sent in a patch to convert FunctionCallInfoData->{arg,argisnull} into an array of NullableDatum (new type, a struct of Datum and bool), and then use a variable length array for the arguments. This gets the size of that data structure down from 936 bytes no matter what to 64 bytes in the very common 2-argument case. Andrew Dunstan sent in a patch to extend and slightly refactor perl checking. Andrew Dunstan sent in a patch to make the MSVC scripts work better on the buildfarm, and possibly elsewhere. Konstantin Knizhnik sent in two more revisions of a patch to implement libpq compression. Robbie Harwood sent in another revision of a patch to implement GSSAPI encryption. Amit Khandekar sent in another revision of a patch to fix a concurrency bug in UPDATE of a partition key. Melanie Plageman sent in a patch to fix a bug in collation. David Fetter sent in a PoC patch to trim trailing whitespace in vim and emacs. Teodor Sigaev sent in three more revisions of a patch to optimize GROUP BY. Michaël Paquier sent in two more revisions of a patch to rework scram_channel_binding to protect from downgrade attacks. Rajkumar Raghuwanshi sent in a patch to add tests for partition-wise join with partitioned tables containing a default partition. Nico Williams sent in another revision of a patch to add an ALWAYS DEFERRED option for CONSTRAINTS and CONSTRAINT TRIGGERs. Heikki Linnakangas sent in a patch to push down JOIN clauses into subqueries. Peter Eisentraut sent in another revision of a patch to enable using file cloning in pg_upgrade. David Rowley and Ashutosh Bapat traded patches to allow direct lookups of AppendRelInfo by child relid. Kyotaro HORIGUCHI sent in a patch to fix wrong behavior during crash recovery. Peter Eisentraut sent in a patch to a patch that allows declaring cursors over prepared. Peter Eisentraut sent in a patch to enable declaring cursors over prepared statements. David Rowley, Álvaro Herrera, and Amit Langote traded patches to fix some issues with partition constraints. Dagfinn Ilmari Mannsåker sent in a patch to fix excess enreferencing in plperl jsonb transform. Peter Da Silva sent in a patch to add a PL/Tcl function to detect when a request has been canceled. Laurenz Albe sent in a patch to build pg_test_fsync as backend code. Michaël Paquier sent in a patch to check the OpenSSL version available on Windows. David Rowley sent in a patch to run-time prune only for partitioned tables.
В списке pgsql-announce по дате отправления:
Следующее
От: Bo PengДата:
Сообщение: Pgpool-II 3.7.4, 3.6.11, 3.5.15 and 3.4.18 are now officiallyreleased.