== PostgreSQL Weekly News - May 24, 2020 ==

== PostgreSQL Weekly News - May 24, 2020 ==

PostgreSQL 13 Beta 1 released. Test!
https://www.postgresql.org/about/news/2040/

== PostgreSQL Product News ==

Joe 0.7.0, a Slack chatbot that helps backend developers and DBAs troubleshoot
and optimize PostgreSQL queries, releaesd.
https://gitlab.com/postgres-ai/joe/-/releases#0.7.0

pg_probackup 2.3.3, a utility to manage backup and recovery of PostgreSQL
database clusters, released.
https://github.com/postgrespro/pg_probackup/releases/tag/2.3.3

== PostgreSQL Jobs for May ==

http://archives.postgresql.org/pgsql-jobs/2020-05/

== PostgreSQL Local ==

PGCon 2020 will take place online on May 26-29, 2020.
https://www.pgcon.org/2020/

FOSS4G 2020, will take place in Calgary, Alberta, Canada August 24-29 2020.
the Call for Papers is currently open at https://2020.foss4g.org/speakers/
https://2020.foss4g.org/

PGDay Ukraine will take place September 5th, 2020 in Lviv at the Bank Hotel.
https://pgday.org.ua/

pgDay Israel 2020 will take place on September 10, 2020 in Tel Aviv.
http://pgday.org.il/

PGDay Austria will take place September 18, 2020 at Schloss Schoenbrunn
(Apothekertrakt) in Vienna.
https://pgday.at/en/

PostgreSQL Conference Europe 2020 will be held on October 20-23, 2020 in Berlin,
Germany. The CfP is open through July 31, 2020 at https://2020.pgconf.eu/callforpapers
https://2020.pgconf.eu/

PG Day Russia will take place in Saint Petersburg on July 9, 2021.
https://pgday.ru/en/2020/

== 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(at)fetter(dot)org(dot)

== Applied Patches ==

Amit Kapila pushed:

- Fix comment in slot.c. Reported-by: Sawada Masahiko Author: Sawada Masahiko
Reviewed-by: Amit Kapila Backpatch-through: 9.5 Discussion:
https://postgr.es/m/CA+fd4k4Ws7M7YQ8PqSym5WB1y75dZeBTd1sZJUQdfe0KJQ-iSA@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/7e041b0c1d13b243b595d0b00145cb1116e4c327

Magnus Hagander pushed:

- Fix typos in README. Author: Daniel Gustafsson
https://git.postgresql.org/pg/commitdiff/a01debe3db3d7f09797460500f217530b502c2de

Peter Eisentraut pushed:

- Translation updates. Source-Git-URL:
https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash:
031ca65d7825c3e539a3e62ea9d6630af12e6b6b
https://git.postgresql.org/pg/commitdiff/ac449d88016080663dbc1cd48004b5a481c034ce

- Remove unnecessary cast. Probably copied from nearby calls where it is
necessary. But this one also casts away constness, so it was doubly annoying.
https://git.postgresql.org/pg/commitdiff/574925bfd0a8175f6e161936ea11d9695677ba09

Bruce Momjian pushed:

- doc: PG 13 relnotes: fix typos. Reported-by: Daniel Gustafsson Discussion:
https://postgr.es/m/0A9D816E-F49C-470B-A23F-8B4AF999382B@yesql.se
https://git.postgresql.org/pg/commitdiff/b31d6efe3d06ca5983bbe63084322b5494b7c3ef

- doc: Simplify mention of unique indexes for NULL control. Discussion:
https://postgr.es/m/2304.1586532634@sss.pgh.pa.us Backpatch-through: 9.5
https://git.postgresql.org/pg/commitdiff/c20fd088f1c5fb5e492f40d427c45b8de38c879c

- doc: suggest 1.1 as a random_page_cost value for SSDs. Reported-by: yigong hu
Discussion:
https://postgr.es/m/CAOxFffcourucFqSk+tZA13ErS3XRYkDy6EeaPff4AvHGiEEuug@mail.gmail.com
Backpatch-through: 9.5
https://git.postgresql.org/pg/commitdiff/1c2ff3ef07d25ca4d291d35f8a31fe513fde58ab

- doc: PG 13 relnotes: fix FETCH FIRST ... WITH TIES xreflabel. Reported-by:
Erwin Brandstetter Discussion:
https://postgr.es/m/CAGHENJ4X626ZfYhondXSP4sQgC5zDtsp_LNg1QaD+U7vfgYXQQ@mail.gmail.com
Backpatch-through: head
https://git.postgresql.org/pg/commitdiff/6ed02e6ac3aac86e8f527e111064012e7911cf43

- doc: PG 13 relnotes: Improve FETCH link. Reported-by: Erwin Brandstetter
Discussion:
https://postgr.es/m/CAGHENJ4X626ZfYhondXSP4sQgC5zDtsp_LNg1QaD+U7vfgYXQQ@mail.gmail.com
Backpatch-through: head
https://git.postgresql.org/pg/commitdiff/10e1521f5c29da2dbe331462feb5408d5ef16915

Tom Lane pushed:

- Remove unused variables. g_comment_start and g_comment_end have been unused
since commit 30ab5bd43d8f2082659191de8ae19be98c960ad7. Daniel Gustafsson
Discussion: https://postgr.es/m/2CA1BA9F-CDF9-41BE-96A1-2EFD2A3EA6CA@yesql.se
https://git.postgresql.org/pg/commitdiff/fe0062c900efa5618197a8e3c88b027e93248db4

- Stamp 13beta1.
https://git.postgresql.org/pg/commitdiff/7966b7980138ebcee7ae986ebcc393aea38a35c0

- part_strategy does not need its very own keyword classification. This should
be plain old ColId. Making it so makes the grammar less complicated, and
makes the compiled tables a kilobyte or so smaller (likely because they don't
have to deal with a keyword classification that's not used anyplace else).
https://git.postgresql.org/pg/commitdiff/c7d65a252cdb7219deb48899fa643c5fd2cc3877

Álvaro Herrera pushed:

- WITH TIES: number of rows is optional and defaults to one. FETCH FIRST .. ONLY
implements this correctly, but we missed to include it for FETCH FIRST .. WITH
TIES in commit 357889eb17bb. Author: Vik Fearing Discussion:
https://postgr.es/m/6aa690ef-551d-e24f-2690-c38c2442947c@postgresfriends.org
https://git.postgresql.org/pg/commitdiff/c301c2e739c642199f9e4c62d867dc7bd5ef0fd1

- doc: Adding a partition does not require Access Exclusive lock. This doc
update was missed in 898e5e3290a7. Backpatch to 12. Pointed out by Pavel
Luzanov Discussion:
https://postgr.es/m/642e9fbc-b832-698b-9a8f-d626afd7014d@postgrespro.ru
https://git.postgresql.org/pg/commitdiff/e1218f59ea4c0605e72298fa121d5aef4c66def2

- Fix two typos in a comment. They were introduced in 898e5e3290a7; backpatch to
12.
https://git.postgresql.org/pg/commitdiff/c99cec96b8b1e067744b8a70961a3447a2293de0

Peter Geoghegan pushed:

- Reconsider nbtree page deletion assertion. Commit 624686abcf8 added an
assertion that verified that _bt_search successfully relocated the leaf page
undergoing deletion. Page deletion cannot deal with the case where the
descent stack is to the right of the page, so this seemed critical (deletion
can only handle the case where the descent stack is to the left of the
leaf/target page). However, the assertion went a bit too far. Since only a
buffer pin is held on the leaf page throughout the call to _bt_search, nothing
guarantees that it can't have split during this small window. And if does
actually split, _bt_search may end up "relocating" a page to the right of the
original target leaf page. This scenario seems extremely unlikely, but it
must still be considered. Remove the assertion, and document how we cope in
this scenario.
https://git.postgresql.org/pg/commitdiff/67b0b2dbf947c2308050e49b4591a4bb0e9650fd

- Doc: Describe CREATE INDEX deduplication strategy. The B-Tree index
deduplication strategy used during CREATE INDEX and REINDEX differs from the
lazy strategy used by retail inserts. Make that clear by adding a new
paragraph to the B-Tree implementation section of the documentation. In
passing, do some copy-editing of nearby deduplication documentation.
https://git.postgresql.org/pg/commitdiff/449e14a5618432f01066c33055229b96666bd925

Michaël Paquier pushed:

- Doc: Replace reference to pg_stat_wal_receiver.received_lsn by flushed_lsn.
Oversight in 2c8dd05d, where the view's column has been renamed. Reported-by:
Fujii Masao Discussion:
https://postgr.es/m/c049ffcf-d2fe-90f7-c8ba-0741035aa6a7@oss.nttdata.com
https://git.postgresql.org/pg/commitdiff/a56e7046d6f2a2ad23ffb9083eba9bc822f18881

- Doc: Fix description of pg_class.relreplident. The description missed a comma
and lacked an explanation of what happens with REPLICA IDENTITY USING INDEX
when the dependent index is dropped. Author: Marina Polyakova Reviewed-by:
Daniel Gustafsson, Michael Paquier Discussion:
https://postgr.es/m/ad1a0badc32658b1bbb07aa312346a1d@postgrespro.ru
Backpatch-through: 9.5
https://git.postgresql.org/pg/commitdiff/39cb2ee09cf900454c1bf14f56048b40c840a490

- Fix MSVC installations with multiple "configure" files detected. When
installing binaries and libraries using the MSVC installation routines, the
operation gets done after moving to the root folder, whose location is
detected by checking if "configure" exists two times in a row. So, calling
the installation script from src/tools/msvc/ with an extra "configure" file
four levels up the root path of the code tree causes the execution to go
further up, leading to a failure in finding the builds. This commit fixes the
issue by moving to the root folder of the code tree only once, when necessary.
Author: Arnold Müller Reviewed-by: Daniel Gustafsson Discussion:
https://postgr.es/m/16343-f638f67e7e52b86c@postgresql.org Backpatch-through:
9.5
https://git.postgresql.org/pg/commitdiff/d2a9959907a03682f4fe182086f9936aca6b2a4f

- Use explicit_bzero() when clearing sslpassword in libpq. Since 74a308c, any
security-sensitive information gets cleared from memory this way. This was
forgotten in 4dc6355. Author: Daniel Gustafsson Reviewed-by: Peter
Eisentraut, Michael Paquier Discussion:
https://postgr.es/m/935443BA-D42E-4CE0-B181-1AD79E6DD45A@yesql.se
https://git.postgresql.org/pg/commitdiff/e4db972ed5f12c09403ff0be24e12e5d4032aaaa

- Add missing invocations to object access hooks. The following commands have
been missing calls to object access hooks InvokeObjectPost{Create|Alter}Hook
normally applied to all commands: - ALTER RULE RENAME TO - ALTER USER MAPPING
- CREATE ACCESS METHOD - CREATE STATISTICS Thanks also to Robert Haas for the
discussion. Author: Mark Dilger Reviewed-by: Álvaro Herrera, Michael Paquier
Discussion:
https://postgr.es/m/435CD295-F409-44E0-91EC-DF32C7AFCD76@enterprisedb.com
https://git.postgresql.org/pg/commitdiff/a995b371ae29de2d38c4b7881cf414b1560e9746

Noah Misch pushed:

- Clear some style deviations.
https://git.postgresql.org/pg/commitdiff/3350fb5d1f9d73de15428e9bfa83dce96421fc14

Etsuro Fujita pushed:

- Adjust indentation in src/backend/optimizer/README. The previous indentation
of optimizer functions was unclear; adjust the indentation dashes so that a
deeper level of indentation indicates that the outer optimizer function calls
the inner one. Author: Richard Guo, with additional change by me Reviewed-by:
Kyotaro Horiguchi Discussion:
https://postgr.es/m/CAMbWs4-U-ogzpchGsP2BBMufCss1hktm%2B%2BeTJK_dUC196pw0cQ%40mail.gmail.com
https://git.postgresql.org/pg/commitdiff/bb2ae6fa47e5d84b6c5a9e3845021e7df031ec32

Fujii Masao pushed:

- doc: Add note about I/O timing information in EXPLAIN and pg_stat_database.
Explain that the followings are tracked only when track_io_timing GUC is
enabled. - blk_read_time and blk_write_time in pg_stat_database - time spent
reading and writing data file blocks in EXPLAIN output with BUFFERS option
Whther track_io_timing is enabled affects also blk_read_time and
blk_write_time in pg_stat_statements, but which was already documented.
Author: Atsushi Torikoshi Reviewed-by: Fujii Masao Discussion:
https://postgr.es/m/CACZ0uYHo_NwbxpLH76OGF-O=13tkR0ZM0zeyGEhZ+JEXZVRyCA@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/eaae947e2b99a84c8f321fe084d87daff0f77d02

== Pending Patches ==

Pavel Borisov sent in another revision of a patch to fix a bug that manifested
as GIN index search sometimes losing results.

Greg Nancarrow sent in another revision of a patch to enhance libpq
target_session_attrs and add target_server_type.

Joe Wildish sent in a patch to add an edit-and-execute command to psql
analogous to (and called the same way as) to bash's <C>-x <C>-e.

Pavel Stěhule sent in a patch to make it possible to use FOR on an unbound
cursor in PL/pgsql.

Tom Lane sent in a patch to make pq_begintypsend more efficient.

Álvaro Herrera sent in a patch to make CreateCheckPoint return bool.

Masahiko Sawada sent in another revision of a patch to support atomic commit
among multiple foreign servers.

Antonin Houska sent in another revision of a patch to implement aggregate
pushdown.

Daniel Gustafsson sent in a patch to disallow --role combined with
--use-set-session-authorization in pg_restore.

Michaël Paquier sent in two revisions of a patch to expand the use of
check_canonical_path() for more GUCs.

Peter Eisentraut sent in a patch to do some refactoring in the grammar around
the commands COMMENT, DROP, SECURITY LABEL, and ALTER EXTENSION ... ADD/DROP.

Masahiko Sawada sent in another revision of a patch to fix a bug that manifested
as xid wraparound danger due to INDEX_CLEANUP false.

Andy Fan sent in a patch to Add query characters information to
pg_stat_statements, which will be helpful to: find which query is missing an
index more accurately, and find which query is using subplan/subquery which are
usually bad for the optimizer.

Jeff Davis and Tomáš Vondra traded patches to fix some inefficiencies in hashagg
spill I/O pattern and costing.

David Rowley sent in a patch to add a new node type that can handle the caching.

Peter Eisentraut sent in a patch to implement the SEARCH and CYCLE clauses for
recursive CTEs.

Thomas Munro sent in a PoC patch to use larger step sizes for Parallel Seq Scan.

John Naylor sent in a patch to tweak the set of candidate multipliers for
generating perfect hash functions, and use perfect hashing for the NFC and NFKC
Unicode normalization quick checks.

Kyotaro HORIGUCHI and Tatsuro Yamada traded patches to expose the counters of
plancache to pg_prepared_statements.

Pavel Stěhule sent in another revision of a patch to implement schema variables.

David Gilman sent in two more revisions of a patch to remove an unused seek
check in tar dump format, scan all ToCs when restoring a custom dump file
without offsets, and add an integration test for out-of-order ToC requests in
pg_restore.

Michaël Paquier sent in a patch to add some more tests with USING INDEX
replident and dropped indexes.

Dilip Kumar sent in another revision of a patch to fix an infelicity between
logical_work_mem and logical streaming of large in-progress transactions.

Thomas Munro sent in a patch to fix a race condition that could corrupt
pg_control.

Amit Khandekar sent in a patch to inline a couple of functions in pl_exec.c.

Julien Rouhaud sent in another revision of a patch to implement collation
versioning.

Vik Fearing sent in a patch to provide default GUCs for EXPLAIN options.