Skip site navigation (1) Skip section navigation (2)

== PostgreSQL Weekly News - January 01 2017 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - January 01 2017 ==
Date: 2017-01-01 21:45:21
Message-ID: 20170101214521.GA22193@fetter.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-announce
== PostgreSQL Weekly News - January 01 2017 ==

== PostgreSQL Product News ==

pgpool-II Pgpool-II 3.6.1, 3.5.5, 3.4.9, 3.3.13, 3.2.18 and 3.1.21 
released.  Pgpool-II 3.1.21 is the final release of the 3.1.x series.
http://www.pgpool.net/docs/latest/en/html/release.html

PL/Proxy 2.7, a database partitioning system implemented as PL language, released.
https://plproxy.github.io

== PostgreSQL Local ==

PGConf India 2017 will be on March 2-3, 2017 in Bengaluru, Karnataka.
http://pgconf.in/

PostgreSQL(at)SCaLE will take place on March 2-3, 2017, at Pasadena Convention
Center, as part of SCaLE 15X.
http://www.socallinuxexpo.org/scale/15x/

PgConf.Russia 2017 will take place on 15-17 March 2017 in Moscow.
https://pgconf.ru/en

PGDay Asia 2017 will be held March 17-18 in Singapore.
The CfP closes January 16, 2017.
http://tinyurl.com/pgDay-Asia-2017-Cfp

Nordic PGDay 2017 will be held in Stockholm, Sweden, at the Sheraton
Hotel, on March 21, 2017.  The CfP is open until January 9, 2017.
https://2017.nordicpgday.org/cfp/

pgDay Paris 2017 will be held in Paris, France on March 23, 2017.
The CfP is open until January 9, 2017.
http://2017.pgday.paris/callforpapers/

PGCon 2017 will take place in Ottawa on 23-26 May.  Proposals are due by
19 Jan 2017.
http://www.pgcon.org/2017/papers.php

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

Tom Lane pushed:

- Remove triggerable Assert in hashname().  hashname() asserted that the key
  string it is given is shorter than NAMEDATALEN.  That should surely always be
  true if the input is in fact a regular value of type "name".  However, for
  reasons of coding convenience, we allow plain old C strings to be treated as
  "name" values in many places.  Some SQL functions accept arbitrary "text"
  inputs, convert them to C strings, and pass them otherwise-untransformed to
  syscache lookups for name columns, allowing an overlength input value to
  trigger hashname's Assert.  This would be a DOS problem, except that it only
  happens in assert-enabled builds which aren't recommended for production.  In
  a production build, you'll just get a name lookup error, since regardless of
  the hash value computed by hashname, the later equality comparison checks
  can't match.  Likewise, if the catalog lookup is done by seqscan or indexscan
  searches, there will just be a lookup error, since the name comparison
  functions don't contain any similar length checks, and will see an overlength
  input as unequal to any stored entry.  After discussion we concluded that we
  should simply remove this Assert.  It's inessential to hashname's own
  functionality, and having such an assertion in only some paths for name lookup
  is more of a foot-gun than a useful check.  There may or may not be a case for
  the affected callers to do something other than let the name lookup fail, but
  we'll consider that separately; in any case we probably don't want to change
  such behavior in the back branches.  Per report from Tushar Ahuja.  Back-patch
  to all supported branches.  Report:
  https://postgr.es/m/7d0809ee-6f25-c9d6-8e74-5b2967830d49@enterprisedb.com
  Discussion: https://postgr.es/m/17691.1482523168@sss.pgh.pa.us
  http://git.postgresql.org/pg/commitdiff/54386f3578258caa5a1de97c434eee2c9ee2ab06

- Fix interval_transform so it doesn't throw away non-no-op casts.
  interval_transform() contained two separate bugs that caused it to sometimes
  mistakenly decide that a cast from interval to restricted interval is a no-op
  and throw it away.  First, it was wrong to rely on dt.h's field type macros to
  have an ordering consistent with the field's significance; in one case they do
  not.  This led to mistakenly treating YEAR as less significant than MONTH, so
  that a cast from INTERVAL MONTH to INTERVAL YEAR was incorrectly discarded.
  Second, fls(1<<k) produces k+1 not k, so comparing its output directly to
  SECOND was wrong.  This led to supposing that a cast to INTERVAL MINUTE was
  really a cast to INTERVAL SECOND and so could be discarded.  To fix, get rid
  of the use of fls(), and make a function based on intervaltypmodout to produce
  a field ID code adapted to the need here.  Per bug #14479 from Piotr
  Stefaniak.  Back-patch to 9.2 where transform functions were introduced,
  because this code was born broken.  Discussion:
  https://postgr.es/m/20161227172307.10135.7747@wrigleys.postgresql.org
  http://git.postgresql.org/pg/commitdiff/f0774abde868e0b5a2acbe75b5028884752f739d

- Remove manual breaks in NodeTag assignments to fix duplicate tag numbers.
  Commit f0e44751d added new node tags at a place in the tag numbering where
  there was no daylight left before the next hard-coded number, resulting in
  some duplicate tag assignments.  This doesn't seem to have caused any big
  problem so far, but it's surely trouble waiting to happen.  We could adjust
  the manually assigned breakpoints to make more room, but that just leaves the
  same hazard waiting to strike again in future.  What seems like a better idea
  is to get rid of the manual assignments and leave NodeTags to be automatically
  assigned, consecutively from one on up.  This means that any change in the tag
  list forces a backend-wide recompile, but realistically that's usually needed
  anyway.  Discussion: https://postgr.es/m/29670.1482942811@sss.pgh.pa.us
  http://git.postgresql.org/pg/commitdiff/80a7298b9eb7f108ef20be6ee00d9513a43c61a0

- Fix unstable regression test results.  Commit 2ac3ef7a0 added a query with an
  underdetermined output row order; it has failed multiple times in the
  buildfarm since then.  Add an ORDER BY to fix.  Also, don't rely on a DROP
  CASCADE to drop in a well-determined order; that hasn't failed yet but I don't
  trust it much, and we're not saving any typing by using CASCADE anyway.
  http://git.postgresql.org/pg/commitdiff/257d8157205a7be5f9799e8941b922521d678a25

- Avoid assuming that instr_time == struct timeval in pgbench logging.  This
  code was presuming undue familiarity with the contents of the instr_time
  struct.  That was already broken on Windows, and it's about to get broken on
  most other platforms as well.  The simplest solution that preserves the
  current output definition is to just do our own gettimeofday() call here.
  Realistically, the extra cost is probably negligible in comparison to
  everything else that's going on in a pgbench transaction, so it's not worth
  sweating over.  On Windows, the precision delivered by gettimeofday() is lower
  than one could wish, but this is still a big improvement over printing zeroes,
  as the code did before.  Discussion:
  https://postgr.es/m/8837.1483216839@sss.pgh.pa.us
  http://git.postgresql.org/pg/commitdiff/74baa1e3b89c1651ade1afeffc715cac24041e2f

Magnus Hagander pushed:

- Fix typo comments.  Erik Rijkers
  http://git.postgresql.org/pg/commitdiff/6cfa54e384700d4a2124e5c4d7a1eb91e8e0eeb7

- Don't rename .partial files in pg_receivexlog if an error occured.  In 56c7d8d
  the behavior to keep .partial segments around (considered corrupt) in case an
  connection failure occurs was accidentally removed. This would lead to an
  incomplete segment being considered complete.  Author: Michael Paquier
  http://git.postgresql.org/pg/commitdiff/3ea56fffd66fe2c5857f36359ae16d4cabcdeef6

Andrew Dunstan pushed:

- Explain unaccounted for space in pgstattuple.  In addition to space accounted
  for by tuple_len, dead_tuple_len and free_space, the table_len includes page
  overhead, the item pointers table and padding bytes.  Backpatch to live
  branches.
  http://git.postgresql.org/pg/commitdiff/71f996d22125eb6cfdbee6094f44370aa8dec610

Peter Eisentraut pushed:

- Make more use of RoleSpec struct.  Most code was casting this through a
  generic Node.  By declaring everything as RoleSpec appropriately, we can
  remove a bunch of casts and ad-hoc node type checking.  Reviewed-by: Alvaro
  Herrera <alvherre(at)2ndquadrant(dot)com>
  http://git.postgresql.org/pg/commitdiff/2e254130d1d3f16575f2d72952ab23b4e27d035a

- Expand ad-hoc unit abbreviations in function descriptions.  There is no need
  to use abbreviations here, so just write it out for consistency.
  http://git.postgresql.org/pg/commitdiff/27866bd1e88c7b564b42394a0d5b069b015666c4

- Fix typo in comment
  http://git.postgresql.org/pg/commitdiff/db779d941e0a05ea4647455d0b386b38ef58983b

== Pending Patches ==

Pavan Deolasee sent in another revision of a patch to fix some issues in WARM.

Kyotaro HORIGUCHI sent in another revision of a patch to clean up negative cache
of pg_statistic when dropping a relation and clean up negative cache of pg_class
when dropping a schema.

Kyotaro HORIGUCHI sent in another revision of a patch to redesign psql's tab
completion and use that infrastructure to implement IF (NOT) EXISTS completion.

Ashutosh Bapat sent in another revision of a patch to imlement partition-wise
join for join between (declaratively) partitioned tables.

Amit Kapila sent in another revision of a patch to implement WAL for hash
indexes.

Dmitry Dolgov sent in another revision of a patch to implement generic type
subscripting.

Amit Langote sent in five more revisions of a patch to implement declarative
partitioning.

Amit Langote sent in a patch to fix an infelicity between OID columns and table
inheritance.

Mithun Cy sent in two more revisions of a patch to cache hash index meta pages.

Etsuro Fujita sent in another revision of a patch to push more FULL joins to the
PostgreSQL FDW.

Amit Kapila sent in another revision of a patch to implement parallel index
scans.

Nikita Glukhov sent in another revision of a patch to implement recursive
json_populate_record().

Peter Eisentraut sent in another revision of a patch to add ICU support.

Rafia Sabih sent in another revision of a patch to implement parallel index-only
scans.

Amit Kapila sent in a patch to parallelize queries containing subplans.

Thomas Munro sent in a patch to fix dsa tranche registration.

Michaël Paquier sent in two more revisions of a patch to enable pg_receivelog to
enable adjusting compression for tar format.

Peter Eisentraut sent in a patch to add some information about the systemd
RemoveIPC issue to the documentation.

Ideriha Takeshi sent in a patch to add a DECLARE STATEMENT command in ECPG.

Craig Ringer sent in another revision of a patch to introduce
txid_status(bigint) to get status of an xact.

Thomas Munro sent in another revision of a patch to allow measuring replay lag.

Claudio Freire sent in another revision of a patch to enable VACUUM to use more
than 1GB of work mem.

Craig Ringer sent in two revisions of a patch to fix a minor race between
commit_ts slru truncation and lookups.

Tom Lane sent in another revision of a patch to improve RLS planning.

Álvaro Herrera sent in two revisions of a patch to rewrite
HeapSatisfiesHOTAndKey.

Álvaro Herrera sent in two more revisions of a patch to implement indirect
indexes.

Vik Fearing sent in a patch to change the encoding of the French translation
encoding from ISO-8859-1 to UTF-8.

Jim Nasby sent in another revision of a patch to increase pltcl test coverage.

Peter Eisentraut sent in another revision of a patch to add background sessions.

Tom Lane sent in a patch to eliminate gettimeofday() on platforms where better
options are available.

Haribabu Kommi sent in a patch to implement a columnar storage extension.

Fabien COELHO sent in another revision of a patch to fix some pg_stat_statements
query normalization issues with combined queries.

Yury Zhuravlev sent in another revision of a patch to implement a CMake-based
build system.

Petr Jelínek sent in another revision of a patch to implement logical
replication.

Michaël Paquier sent in another revision of a patch to fix a potential data loss
of 2PC files.

Fabrízio de Royes Mello sent in another revision of a patch to implement COMMENT
ON CURRENT DATABASE.

Amit Kapila sent in another revision of a patch to speed up clog Access by
increasing CLOG buffers.

Amit Kapila sent in a patch to fix an issue where group clear xid can leak
semaphore count.

Peter Eisentraut sent in a patch to generate fmgr prototypes automatically.

Peter Eisentraut sent in another revision of a patch to implement sequence data
types.

Peter Eisentraut sent in a patch to put "use strict" in all Perl programs.

Peter Eisentraut sent in a patch to create the INSTALL file via XSLT and Pandoc.
This is one more step on the way to replacing the old tool chain of jade and
lynx.

Peter Eisentraut sent in a patch to automatically casts the result of copyNode()
back to the input type, if the compiler supports something like typeof().

Stas Kelvich sent in another revision of a patch to implement logical decoding
of two-phase transactions.

Magnus Hagander sent in another revision of a patch to support huge pages on
Windows.

Peter Eisentraut sent in another revision of a patch to add identity columns per
the SQL standard.

Magnus Hagander sent in a patch to change the backup and replication defaults to
something more useful.

Peter Eisentraut sent in another revision of a patch to allow DROP FUNCTION to
drop multiple functions in one command.

Peter Eisentraut sent in a patch to implement safer node casting.

Magnus Hagander sent in another revision of a patch to make streaming the
pg_basebackup default.

David Fetter sent in another revision of a patch to add a hook which allows
disabling simple UPDATEs and DELETEs without a WHERE clause.

Thomas Munro sent in a patch to add an isolation test for SERIALIZABLE READ ONLY
DEFERRABLE.

Pavel Stěhule sent in a patch to add some runtime checks to PL/pgsql.

Simon Riggs sent in another revision of a patch to make some changes to the
recovery.conf API.



pgsql-announce by date

Next:From: Euler TaveiraDate: 2017-01-04 12:58:12
Subject: pgquarrel 0.2.0 released
Previous:From: Marko KreenDate: 2016-12-27 14:00:45
Subject: PL/Proxy 2.7

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group