== PostgreSQL Weekly News - June 04 2018 ==

== PostgreSQL Weekly News - June 04 2018 ==

Congratulations to the new PostgreSQL committers, Etsuro Fujita, Peter
Geoghegan, Amit Kapila, Alexander Korotkov, Thomas Munro, Michael Paquier, and
Tomas Vondra!

== PostgreSQL Product News ==

Odyssey, a multi-threaded connection pooler for PostgreSQL, released.
https://github.com/yandex/odyssey

== 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 EST5EDT. Please send English
language ones to david(at)fetter(dot)org, German language to pwn(at)pgug(dot)de, Italian
language to pwn(at)itpug(dot)org(dot)

== Applied Patches ==

Bruce Momjian pushed:

- doc: adjust DECLARE docs to mention FOR UPDATE behavior. Reported-by: Peter
Eisentraut Discussion:
https://postgr.es/m/8dc63ba7-dc56-fc7c-fc16-4fae03e3bfe6@2ndquadrant.com
Author: Peter Eisentraut, Tom Lane, me Backpatch-through: 9.3
https://git.postgresql.org/pg/commitdiff/99164e6952917009929026a9a11e4a500f599c40

- doc: mark 'replaceable' parameter for backup program listing. Reported-by:
Liudmila Mantrova Discussion:
https://postgr.es/m/f3e2c0f5-5266-d626-58d7-b77e1b29d870@postgrespro.ru
Author: Liudmila Mantrova Backpatch-through: 9.3
https://git.postgresql.org/pg/commitdiff/6a75b58065c8da69a259657fc40d18e76157f265

Andrew Dunstan pushed:

- Return a value from Install.pm's lcopy function. Commit 3a7cc727c was a
little over eager about adding an explicit return to this function, whose
value is checked in most call sites. This change reverses that and returns the
expected value explicitly. It also adds a check to the one call site lacking
one.
https://git.postgresql.org/pg/commitdiff/01deec5f8ae64b5120cc8c93d54fe0e19e477b02

- Fix compile-time warnings on all perl code. This patch does two things.
First, it silences a number of compile-time warnings in the msvc tools files,
mainly those due to the fact that in some cases we have more than one package
per file. Second it supplies a dummy Perl library with just enough of the
Windows API referred to in our code to let it run these checks cleanly, even
on Unix machines where the code is never supposed to run. The dummy library
should only be used for that purpose, as its README notes.
https://git.postgresql.org/pg/commitdiff/0039049fb1d76afef05d550823b27731ad7d7b3d

Peter Eisentraut pushed:

- Initialize new jsonb iterator to zero. Use palloc0() instead of palloc() to
create a new JsonbIterator. Otherwise, the isScalar field is sometimes not
initialized. There is probably no impact in practice, but it's cleaner this
way and it avoids future problems.
https://git.postgresql.org/pg/commitdiff/3c9cf069454d80b0b4a54a0a90941a88a97b1122

Teodor Sigaev pushed:

- Move _bt_upgrademetapage() into critical section. Any changes on page should
be done in critical section, so move _bt_upgrademetapage into critical
section. Improve comment. Found by Amit Kapila during post-commit review of
857f9c36. Author: Amit Kapila
https://git.postgresql.org/pg/commitdiff/08186dc05b3eed9c1f29b3349b122487d84ef3eb

Álvaro Herrera pushed:

- Fix grammar. Reported-by: Pavlo Golub Author: Michaël Paquier Discussion:
https://postgr.es/m/152741547.20180530101229@cybertec.at
https://git.postgresql.org/pg/commitdiff/d3b10f0d64e90e9c78b8adc24ab3e38b30ef60bd

- Tweak partitioning documentation wording. For clarity, precision, grammar.
Author: Justin Pryzby Reviewed-by: Amit Langote, Álvaro Herrera Discussion:
https://postgr.es/m/20180523213513.GM30060@telsasoft.com
https://git.postgresql.org/pg/commitdiff/12b9affb32a636777062b3feb5816621363fc108

Noah Misch pushed:

- Reconcile nodes/*funcs.c with PostgreSQL 11 work. This covers new fields in
two outfuncs.c functions having no readfuncs.c counterpart. Thus, this
changes only debugging output.
https://git.postgresql.org/pg/commitdiff/ef3109500030030b0e8d3c1d7f2b409d702cc49a

== Pending Patches ==

Michaël Paquier sent in another revision of a patch to support channel binding
in various TLS implementations.

Andres Freund and Álvaro Herrera traded patches to ensure relcache entries for
nailed relations are accurate.

Craig Ringer sent in two revisions of a patch to install pg_isolation_regress,
not just isolationtester.

Michaël Paquier sent in two revisions of a patch to ensure that
pg_replication_slot_advance returns NULL instead of 0/0 when a slot is not
advanced.

Michaël Paquier sent in two more revisions of a patch to rework
scram_channel_binding to protect from downgrade attacks.

Vik Fearing sent in a patch to implement tab completion in psql for TABLE.

Craig Ringer sent in another revision of a patch to PANIC when we detect a
possible fsync I/O error instead of retrying fsync.

Edmund Horner sent in a patch to remove a redundant psql tab-completion for
CREATE PUBLICATION.

Justin Pryzby sent in a patch to add psql tab completions for several of the
new VACUUM and ANALYZE options.

Michaël Paquier sent in a patch to support tls-server-end-point on old version
(1.0.0 and 1.0.1) of OpenSSL.

Daniel Gustafsson sent in two revisions of a patch to change uses of
bms_num_members() without storing the returned count to use bms_membership(),
which is optimized for that case.

Manuel Kniep sent in a patch to enable passing PGOPTIONS to pg_regress.

Daniel Gustafsson sent in a patch to avoid extra Sort nodes between WindowAggs
when sorting can be reused.

Adrien Nayrat sent in two revisions of a patch to add a new GUC,
log_sample_rate, to reduce the number of queries are actually logged.

David Rowley sent in a patch to allow direct lookups of AppendRelInfo by child
relid.

Teodor Sigaev sent in two revisions of a patch to optimize GROUP BY by allowing
reordering the columns, which then enables using n_distinct to speed up the
process.

Carter Thaxton sent in another revision of a patch to add a --where option to
pg_dump, which allows dumping prearranged subsets of the data.

James Coleman sent in another revision of a patch to implement incremental sort.

Michaël Paquier sent in two revisions of a patch to fix and document lock
handling for in-memory replication xslot data and fix a couple of bugs with
replication slot advancing feature.

Justin Pryzby sent in another revision of a patch to fix some of the
documentation for partition pruning.

Lætitia Avrot sent in a patch to document the fact that CHECK constraints cannot
reliably span tables, at least under pg_dump(all).

Amit Kapila sent in a patch to do some cosmetic cleanups for the patch which
speeds up adding columns with defaults other than NULL.

Dmitry Dolgov sent in a patch to check for stable expressions in partition
pruning.

Emre Hasegeli sent in another revision of a patch to fix the floating point
handling in geometric types.