== PostgreSQL Weekly News - October 28, 2018 == - Mailing list pgsql-announce
From | David Fetter |
---|---|
Subject | == PostgreSQL Weekly News - October 28, 2018 == |
Date | |
Msg-id | 20181028234724.GA15405@fetter.org Whole thread Raw |
List | pgsql-announce |
== PostgreSQL Weekly News - October 28, 2018 == PGDay Argentina 2018 will be held in Buenos Aires on November 21, 2018. The CfP is open through October 31, 2018. http://www.pgday.com.ar/buenosaires2018/?lang=en == PostgreSQL Product News == Pgpool-II 4.0.0 and pgpoolAdmin 4.0.0 released. http://www.pgpool.net/docs/latest/en/html/release-4-0.html barman 2.5, a backup and recovery manager for PostgreSQL, released. https://www.pgbarman.org/barman-2-5-released/ pg_permission 1.0, an extension which uses table data to set norms for access controls and includes tools to check them against the system's actual access controls, released. https://github.com/cybertec-postgresql/pg_permission Benetl 4.9, an ETL tool for postgreSQL, released. http://www.benetl.net PipelineDB v1.0.0, an extension to handle streaming time-series data, released. https://www.pipelinedb.com/blog/pipelinedb-1-0-0-high-performance-time-series-aggregation-for-postgresql == PostgreSQL Jobs for October == http://archives.postgresql.org/pgsql-jobs/2018-10/ == PostgreSQL Local == pgday.Seoul 2018 will be held in Seoul, South Korea on November 3, 2018 in Seoul. Korean language information is here: http://pgday.postgresql.kr/ 2Q PGConf will be on December 4-5, 2018 in Chicago, IL. http://www.2qpgconf.com/ PGConf.ASIA 2018 will take place on December 10-12, 2018 in Akihabara, Tokyo, Japan. http://www.pgconf.asia/EN/2018/ pgDay Paris 2019 will be held in Paris, France on March 12, 2019 at 199bis rue Saint-Martin. The CfP is open until November 30, 2018. http://2019.pgday.paris/callforpapers/ PGConf APAC 2019 will be held in Singapore March 19-21, 2019. The CfP is open at http://2019.pgconfapac.org/cfp through November 16, 2018. http://2019.pgconfapac.org/ PGDay.IT 2019 will take place May 16th and May 17th in Bologna, Italy. The CfP is open at https://2019.pgday.it/en/blog/cfp and the Call for Workshops is at https://2019.pgday.it/en/blog/cfw until January 15, 2019. https://2019.pgday.it/en/ == 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 to david@fetter.org. == Applied Patches == Alexander Korotkov pushed: - Fix some grammar errors in bloom.sgml. Discussion: https://postgr.es/m/CAEepm%3D3sijpGr8tXdyz-7EJJZfhQHABPKEQ29gpnb7-XSy%2B%3D5A%40mail.gmail.com Reported-by: Thomas Munro Backpatch-through: 9.6 https://git.postgresql.org/pg/commitdiff/31ff51adc855e3ffe8e3c20e479b8d1a4508feb8 Michaël Paquier pushed: - Clarify descriptions of relhassubclass and relispartition in pg_class. Three places are fixed, one for each author. Reported-by: Tom Lane Author: Tom Lane, Amit Langote, Michael Paquier Discussion: https://postgr.es/m/82470.1540177167@sss.pgh.pa.us https://git.postgresql.org/pg/commitdiff/55853d666ce5d0024c50dc3d223346df28abfa70 - Set pg_class.relhassubclass for partitioned indexes. Like for relations, switching this parameter is optimistic by turning it on each time a partitioned index gains a partition. So seeing this parameter set to true means that the partitioned index has or has had partitions. The flag cannot be reset yet for partitioned indexes, which is something not obvious anyway as partitioned relations exist to have partitions. This allows to track more conveniently partition trees for indexes, which will come in use with an upcoming patch helping in listing partition trees with an SQL-callable function. Author: Amit Langote Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/80306490-b5fc-ea34-4427-f29c52156052@lab.ntt.co.jp https://git.postgresql.org/pg/commitdiff/17f206fbc824d2b4b14480199ca9ff7dea417eda - List wait events in alphabetical order. This changes the documentation, and the related structures so as everything is consistent. Some wait events were not listed alphabetically since their introduction, others have been added rather randomly. Keeping all those entries in order helps in maintenance, and helps the user looking at the documentation. Author: Michael Paquier, Kuntal Ghosh Discussion: https://postgr.es/m/20181024002539.GI1658@paquier.xyz Backpatch-through: 10, only for the documentation part to avoid an ABI breakage. https://git.postgresql.org/pg/commitdiff/5ef037cf0b9e130120c5a788f1f1048f6242b076 - Add pg_promote function. This function is able to promote a standby with this new SQL-callable function. Execution access can be granted to non-superusers so that failover tools can observe the principle of least privilege. Catalog version is bumped. Author: Laurenz Albe Reviewed-by: Michael Paquier, Masahiko Sawada Discussion: https://postgr.es/m/6e7c79b3ec916cf49742fb8849ed17cd87aed620.camel@cybertec.at https://git.postgresql.org/pg/commitdiff/10074651e3355e2405015f6253602be8344bc829 - Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psql. The change to accept EXECUTE FUNCTION as well as EXECUTE PROCEDURE in CREATE TRIGGER (added by 0a63f99) forgot to tell psql's tab completion system about this. In passing, add tab completion of EXECUTE FUNCTION/PROCEDURE after a complete WHEN ( … ) clause. This change is version-aware, with FUNCTION being selected automatically instead of PROCEDURE depending on the backend version, PROCEDURE being an historical grammar kept for compatibility and considered as deprecated in v11. Author: Dagfinn Ilmari Mannsåker Reviewed-by: Tom Lane, Michael Paquier Discussion: https://postgr.es/m/d8jmur4q4yc.fsf@dalvik.ping.uio.no https://git.postgresql.org/pg/commitdiff/292ef6e2778afb3ecea250fc50326587543ae144 - Improve tab completion of CREATE EVENT TRIGGER in psql. This adds tab completion of the clauses WHEN and EXECUTE FUNCTION|PROCEDURE clauses to CREATE EVENT TRIGGER, similar to CREATE TRIGGER in the previous commit. This has version-dependent logic so as FUNCTION is chosen over PROCEDURE for 11 and newer versions. Author: Dagfinn Ilmari Mannsåker Reviewed-by: Tom Lane, Michael Paquier Discussion: https://postgr.es/m/d8jmur4q4yc.fsf@dalvik.ping.uio.no https://git.postgresql.org/pg/commitdiff/5953c99697621174f50aa219a3cd457212968268 Peter Eisentraut pushed: - Sprinkle some const decorations. These mainly help understanding the function signatures better. https://git.postgresql.org/pg/commitdiff/807e4bc828cff0645d2a776604dc7cdc733b2fd3 - Drop const cast from dlsym() calls. This workaround might be obsolete. We'll see if those "older platforms" mentioned in the comment are still around. Discussion: https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com https://git.postgresql.org/pg/commitdiff/e6f5d1accd3ae170a0baa632bfe3396bdd9b6e92 - Remove get_attidentity(). All existing uses can get this information more easily from the relation descriptor, so the detour through the syscache is not necessary. Reviewed-by: Michael Paquier <michael@paquier.xyz> https://git.postgresql.org/pg/commitdiff/5d7c703a44101f0d686fb66f4ff671429f46a84c - Remove get_atttypmod(). This has been unused since 2004. get_atttypetypmodcoll() is often a better alternative. Reviewed-by: Michael Paquier <michael@paquier.xyz> https://git.postgresql.org/pg/commitdiff/c903bb7b1c3ce82e21d6bd1af1dc45a58cd88455 - Improve unconstify() documentation. Refer to expression instead of variable when appropriate. Discussion: https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com https://git.postgresql.org/pg/commitdiff/f2898de98a5407a8b78f49866ef4931813505ca2 - Apply unconstify() in more places. Discussion: https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com https://git.postgresql.org/pg/commitdiff/0a8590b2a09e7a9e10612bc38d5e872b0c234eca Andrew Dunstan pushed: - Correctly set t_self for heap tuples in expand_tuple. Commit 16828d5c0 incorrectly set an invalid pointer for t_self for heap tuples. This patch correctly copies it from the source tuple, and includes a regression test that relies on it being set correctly. Backpatch to release 11. Fixes bug #15448 reported by Tillmann Schulz Diagnosis and test case by Amit Langote https://git.postgresql.org/pg/commitdiff/040a1df6149f852c3b8de96d9d13258af8a39e23 - Fix typo in regression test comment. per Michael Banck https://git.postgresql.org/pg/commitdiff/4beea5508e80a65a90f3fa857ea34ec71b9d6db2 - Fix perl searchpath for modern perl for MSVC tools. Modern versions of perl no longer include the current directory in the perl searchpath, as it's insecure. Instead of adding the current directory, we get around the problem by adding the directory where the script lives. Problem noted by Victor Wagner. Solution adapted from buildfarm client code. Backpatch to all live versions. https://git.postgresql.org/pg/commitdiff/1df92eeafefac471b8bcb00244452c645e4e14fd == Pending Patches == Alexander Korotkov sent in another revision of a patch to remove some snapshot functions from TableAmRoutine and add costing functions to the tableam interface. Oleg Bartunov sent in a patch to remove documentation for the @@@ operator. John Naylor sent in another revision of a patch to avoid creation of the free space map for small tables. Haribabu Kommi sent in four more revisions of a patch to remove the old slot interface file, add grammar support for CREATE AS ... USING, remove an extra tuple visibility check, and add an API to create INIT_FORKNUM file with wrapper table_create_init_fork. Thomas Munro sent in another revision of a patch to add a synchronous replay mode for avoiding stale reads on hot standbys. Tom Lane sent in a patch to process SIGPIPE normally in COPY ... FROM PROGRAM. Pavel Stěhule sent in another revision of a patch to implement schema variables. Ryohei Nagaura sent in a patch to make it possible to use TCP_USER_TIMEOUT. Hironobu SUZUKI and Fabien COELHO traded patches to pgbench to add pseudo-random permutation function. David Fetter sent in a patch to increase the default resolution of log timestamps from milliseconds to microseconds. Thomas Munro sent in another revision of a patch to add a WL_EXIT_ON_PM_DEATH pseudo-event. Andrey V. Lepikhov sent in two more revisions of a patch to fix handling of the WAL record buffer pointer. Fabien COELHO sent in two more revisions of a patch to fix some issues in how libpq handles host IPs. Michaël Paquier sent in a patch to fix an infelicity in handling userid assignment with savepoints. Álvaro Herrera sent in a patch to have isolationtester prefix WARNING with session name. Ryo Matsumura sent in a patch to add a BYTEA data type to ECPG. David Rowley sent in a patch to make it obvious that there's meant to be exactly 1 item in the partexprs List for each zero-valued partattrs element. MyungKyu LIM sent in another revision of a patch to add entry creation timestamp column to pg_stat_replication. Konstantin Knizhnik sent in another revision of a patch to add built-in connection pooling. Kyotaro HORIGUCHI sent in another revision of a patch to make pg_verify_checksums conscious of unknown files and common-ize the file type checker for checksums. Marius Timmer sent in another revision of a patch to add a new auth option: clientcert=verify-full. Peter Eisentraut sent in another revision of a patch to lower the lock level for renaming indexes. Álvaro Herrera sent in another revision of a patch to reduce the locking needed in order to ATTACH/DETACH partitions. Nikolay Samokhvalov sent in a patch to better document fail-back, specifically the conditions under which a previously failed publisher node can be made the new publisher without running pg_rewind or similar. Dmitry Dolgov sent in another revision of a patch to improve the algorithm for partition-wise JOINs. Kyotaro HORIGUCHI sent in two more revisions of a patch to add a WAL relief vent for replication slots, and columns "status" and "remain" to pg_replication_slot, which help monitor max_slot_wal_keep_size. Ian Barwick sent in two revisions of a patch to document the new pg_promote function. Amit Langote sent in another revision of a patch to speed up planning with partitions. Fabien COELHO sent in a patch to fix psql \conninfo and \connect when using hostaddr. David Rowley sent in a patch to make ordered partitioned table scans by using Append rather than MergeAppend in some cases when it can be shown to be the correct thing to do. Dilip Kumar sent in two revisions of a patch to fix a bug in childrel statistics access. Daniel Gustafsson sent in two revisions of a patch to consolidate option checking in pg_restore. Tomáš Vondra sent in another revision of a patch to add a WHEN option to COPY ... FROM. Andrey Borodin sent in another revision of a patch to add GiST support to VACUUM. Tomáš Vondra sent in another revision of a patch to add a WITH TIES option to FETCH FIRST. Daniel Gustafsson sent in another revision of a patch to support the Secure Transport SSL library on macOS as an OpenSSL alternative. Tomáš Vondra sent in a patch to fix some tests in the upcoming JSONPATH patch.
pgsql-announce by date: