== PostgreSQL Weekly News - June 04 2018 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - June 04 2018 ==
Date: 2018-06-03 22:25:41
Message-ID: 20180603222541.GA11266@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-announce

== 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.

== PostgreSQL Jobs for June ==


== PostgreSQL Local ==

PGDay.IT 2018 will take place in Lazise on Lake Garda on June 29, 2018.

Swiss PGDay 2018 will take place in Rapperswil (near Zurich) on June 29, 2018.
Registration is open through June 28, 2018.

PGConf.Brazil 2018 will take place in São Paulo, Brazil on August 3-4 2018.

PG Day France 2018 will take place in Marseille on June 26, 2018.

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

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)

PostgresConf South Africa 2018 will take place in Johannesburg on October 9, 2018
The Call for Papers is open through June 30, 2018.

== 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:
Author: Peter Eisentraut, Tom Lane, me Backpatch-through: 9.3

- doc: mark 'replaceable' parameter for backup program listing. Reported-by:
Liudmila Mantrova Discussion:
Author: Liudmila Mantrova Backpatch-through: 9.3

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

- 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.

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.

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

Álvaro Herrera pushed:

- Fix grammar. Reported-by: Pavlo Golub Author: Michaël Paquier Discussion:

- Tweak partitioning documentation wording. For clarity, precision, grammar.
Author: Justin Pryzby Reviewed-by: Amit Langote, Álvaro Herrera Discussion:

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.

== 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

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

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

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

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

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

Browse pgsql-announce by date

  From Date Subject
Next Message Tatsuo Ishii 2018-06-04 04:29:20 Call for Papers - PGConf.ASIA 2018
Previous Message Vladimir Borodin 2018-05-30 13:22:48 Open sourcing Odyssey: scalable connection pooler