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

== PostgreSQL Weekly News - March 12 2017 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - March 12 2017 ==
Date: 2017-03-12 23:41:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
== PostgreSQL Weekly News - March 12 2017 ==

PostgresOpen will occur September 6-8, 2017 in San Francisco.
The CfP will open  March 24, 2017.

== PostgreSQL Product News ==

psqlODBC 09.06.0200 released.

== PostgreSQL Jobs for March ==

== PostgreSQL Local ==

PgConf.Russia 2017 will take place on 15-17 March 2017 in Moscow.

PGDay Asia 2017 will be held March 17-18 in Singapore.

Nordic PGDay 2017 will be held in Stockholm, Sweden, at the Sheraton
Hotel, on March 21, 2017.

pgDay Paris 2017 will be held in Paris, France on March 23, 2017.

PGConf US 2017 will be on March 28-31 in Jersey City, New Jersey.

PGCon 2017 will take place in Ottawa on 23-26 May.

Postgres Vision will take place in Boston, June 26 - 28, 2017.

Swiss PGDay in Rapperswil will take place June 30, 2017.
The CfP is open through April 14, 2017.

== PostgreSQL in the News ==

Planet PostgreSQL:

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

Simon Riggs pushed:

- Allow partitioned tables to be dropped without CASCADE.  Record partitioned
  table dependencies as DEPENDENCY_AUTO rather than DEPENDENCY_NORMAL, so that
  DROP TABLE just works.  Remove all the tests for partitioned tables where
  earlier work had deliberately avoided using CASCADE.  Amit Langote, reviewed
  by Ashutosh Bapat and myself

- Reduce lock levels for table storage params related to planning.  The
  following parameters are now updateable with ShareUpdateExclusiveLock
  effective_io_concurrency parallel_workers seq_page_cost random_page_cost
  n_distinct n_distinct_inherited Simon Riggs and Fabrízio Mello

- Enhance docs for ALTER TABLE lock levels of storage parms.  As requested by
  Robert Haas

- Ensure ThisTimeLineID is valid before START_REPLICATION.  Craig Ringer

- Allow pg_dumpall to dump roles w/o user passwords.  Add new option
  --no-role-passwords which dumps roles without passwords.  Since we don’t need
  passwords, we choose to use pg_roles in preference to pg_authid since access
  may be restricted for security reasons in some configrations.  Robins Tharakan
  and Simon Riggs

Peter Eisentraut pushed:

- Reorder the asynchronous libpq calls for replication connection.  Per libpq
  documentation, the initial state must be PGRES_POLLING_WRITING.  Failing to do
  that appears to cause some issues on some Windows systems.  From: Petr Jelinek

- Combine several DROP variants into generic DropStmt.  Combine DROP of FOREIGN
  DATA WRAPPER, SERVER, POLICY, RULE, and TRIGGER into generic DropStmt grammar.
  Reviewed-by: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> Reviewed-by: Michael Paquier

- Replace LookupFuncNameTypeNames() with LookupFuncWithArgs().  The old function
  took function name and function argument list as separate arguments.  Now that
  all function signatures are passed around as ObjectWithArgs structs, this is
  no longer necessary and can be replaced by a function that takes
  ObjectWithArgs directly.  Similarly for aggregates and operators.
  Reviewed-by: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> Reviewed-by: Michael Paquier

- Add operator_with_argtypes grammar rule.  This makes the handling of operators
  similar to that of functions and aggregates.  Rename node FuncWithArgs to
  ObjectWithArgs, to reflect the expanded use.  Reviewed-by: Jim Nasby
  <Jim(dot)Nasby(at)BlueTreble(dot)com> Reviewed-by: Michael Paquier

- Use class_args field in opclass_drop.  This makes it consistent with the usage
  in opclass_item.  Reviewed-by: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
  Reviewed-by: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>

- Remove objname/objargs split for referring to objects.  In simpler times, it
  might have worked to refer to all kinds of objects by a list of name
  components and an optional argument list.  But this doesn't work for all
  objects, which has resulted in a collection of hacks to place various other
  nodes types into these fields, which have to be unpacked at the other end.
  This makes it also weird to represent lists of such things in the grammar,
  because they would have to be lists of singleton lists, to make the unpacking
  work consistently.  The other problem is that keeping separate name and args
  fields makes it awkward to deal with lists of functions.  Change that by
  dropping the objargs field and have objname, renamed to object, be a generic
  Node, which can then be flexibly assigned and managed using the normal Node
  mechanisms.  In many cases it will still be a List of names, in some cases it
  will be a string Value, for types it will be the existing Typename, for
  functions it will now use the existing ObjectWithArgs node type.  Some of the
  more obscure object types still use somewhat arbitrary nested lists.
  Reviewed-by: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> Reviewed-by: Michael Paquier

- Allow dropping multiple functions at once.  The generic drop support already
  supported dropping multiple objects of the same kind at once.  But the
  previous representation of function signatures across two grammar symbols and
  structure members made this cumbersome to do for functions, so it was not
  supported.  Now that function signatures are represented by a single
  structure, it's trivial to add this support.  Same for aggregates and
  operators.  Reviewed-by: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> Reviewed-by:
  Michael Paquier <michael(dot)paquier(at)gmail(dot)com>

- Fix segfault in ALTER PUBLICATION/SUBSCRIPTION RENAME.  From: Masahiko Sawada
  <sawada(dot)mshk(at)gmail(dot)com> Reported-by: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>

- pg_waldump: Remove extra newline in error message.  fatal_error() already
  prints out a trailing newline.

- Enable replication connections by default in pg_hba.conf.  initdb now
  initializes a pg_hba.conf that allows replication connections from the local
  host, same as it does for regular connections.  The connecting user still
  needs to have the REPLICATION attribute or be a superuser.  The intent is to
  allow pg_basebackup from the local host to succeed without requiring
  additional configuration.  Michael Paquier <michael(dot)paquier(at)gmail(dot)com> and me

- Use SQL standard error code for nextval.

- Create INSTALL file via XSLT.  As before, create an INSTALL.html file for
  processing with lynx, but use xsltproc and a new XSLT stylesheet instead of
  jade and DSSSL.  Replacing jade with xsltproc removes jade from the
  requirements for distribution building.  Reviewed-by: Magnus Hagander

- dblink: Replace some macros by static functions.  Also remove some unused code
  and the no longer useful dblink.h file.  Reviewed-by: Tsunakawa, Takayuki

- dblink: Change some StringInfo to StringInfoData.  For consistency with other
  code and to avoid wasting some small amount of memory.  From: Tsunakawa,
  Takayuki <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>

- Improve gitignore file.  One file was listed under a wrong comment.

- pg_dump: Fix dumping of publications.  Dumping a publication with more than
  one table crashed pg_dump.  patch by Amit Langote
  <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, test by me

Robert Haas pushed:

- Fix user-after-free bug.  Introduced by commit
  aea5d298362e881b13d95a48c5ae116879237389.  Patch from Amit Kapila.  Issue
  discovered independently by Amit Kapila and Ashutosh Sharma.

- Fix incorrect comments.  Commit 19dc233c32f2900e57b8da4f41c0f662ab42e080
  introduced these comments.  Michael Paquier noticed that one of them had a
  typo, but a bigger problem is that they were not an accurate description of
  what the code was doing.  Patch by me.

- Mark pg_start_backup and pg_stop_backup as parallel-restricted.  They depend
  on backend-private state that will not be synchronized by the parallel
  machinery, so they should not be marked parallel-safe.  This issue also exists
  in 9.6, but we obviously can't do anything about 9.6 clusters that already
  exist.  Possibly this could be back-patched so that future 9.6 clusters would
  come out OK, or possibly we should back-patch some other fix, but that would
  need more discussion.  David Steele, reviewed by Michael Paquier Discussion:

- Fix parallel hash join path search.  When the very cheapest path is not
  parallel-safe, we want to instead use the cheapest unparameterized path that
  is.  The old code searched innerrel->cheapest_parameterized_paths, but that
  isn't right, because the path we want may not be in that list.  Search
  innerrel->pathlist instead.  Spotted by Dilip Kumar.  Discussion:

- Preparatory refactoring for parallel merge join support.  Extract the logic
  used by hash_inner_and_outer into a separate function,
  get_cheapest_parallel_safe_total_inner, so that it can also be used to plan
  parallel merge joins.  Also, add a require_parallel_safe argument to the
  existing function get_cheapest_path_for_pathkeys, because parallel merge join
  needs to find the cheapest path for a given set of pathkeys that is
  parallel-safe, not just the cheapest one overall.  Patch by me, reviewed by
  Dilip Kumar.  Discussion:

- Fix wrong word in comment.  Third time's the charm.

- Document what values postgres_fdw sets for each parameter it sets.  David
  Rader, reviewed by me.

- Remove duplicated word.  Amit Langote

- Fix relcache reference leak.  Reported by Kevin Grittner.  Faulty commit
  identified by Tom Lane.  Patch by Amit Langote, reviewed by Michael Paquier.

- Give partitioned table "p" in regression tests a less generic name.  And don't
  drop it, so that we improve the coverage of the pg_upgrade regression tests.
  Amit Langote, per a gripe from Tom Lane Discussion:

- Consider parallel merge joins.  Commit
  45be99f8cd5d606086e0a458c9c72910ba8a613d took the position that performing a
  merge join in parallel was not likely to work out well, but this conclusion
  was greeted with skepticism even at the time.  Whether it was true then or
  not, it's clearly not true any more now that we have parallel index scan.
  Dilip Kumar, reviewed by Amit Kapila and by me.  Discussion:

- Properly initialize variable.  Commit 3bc7dafa9bebbdaa1bbf0da0798d29a8bdaf6a8f
  forgot to do this.  Noted while experimenting with valgrind.

- Improve postgresql.conf.sample comments about parallel workers.  David Rowley,
  reviewed by Amit Kapila Discussion:

- hash: Refactor hash index creation.  The primary goal here is to move all of
  the related page modifications to a single section of code, in preparation for
  adding write-ahead logging.  In passing, rename _hash_metapinit to _hash_init,
  since it initializes more than just the metapage.  Amit Kapila.  The larger
  patch series of which this is a part has been reviewed and tested by Álvaro
  Herrera, Ashutosh Sharma, Mark Kirkwood, Jeff Janes, and Jesper Pedersen.

- tidbitmap: Support shared iteration.  When a shared iterator is used, each
  call to tbm_shared_iterate() returns a result that has not yet been returned
  to any process attached to the shared iterator.  In other words, each
  cooperating processes gets a disjoint subset of the full result set, but all
  results are returned exactly once.  This is infrastructure for parallel bitmap
  heap scan.  Dilip Kumar.  The larger patch set of which this is a part has
  been reviewed and tested by (at least) Andres Freund, Amit Khandekar, Tushar
  Ahuja, Rafia Sabih, Haribabu Kommi, and Thomas Munro.  Discussion:

- Fix parallel index and index-only scans to fall back to serial.  Parallel
  executor nodes can't assume that parallel execution will happen in every case
  where the plan calls for it, because it might not work out that way.  However,
  parallel index scan and parallel index-only scan failed to do the right thing
  here.  Repair.  Amit Kapila, per a report from me.  Discussion:

- Remove inclusion of postgres.h from a few header files.  Thomas Munro, per
  project policy articuled by Andres Freund and Tom Lane.  Discussion:

- Add tests for foreign partitions.  Amit Langote, reviewed by Ashutosh Bapat

- Support parallel bitmap heap scans.  The index is scanned by a single process,
  but then all cooperating processes can iterate jointly over the resulting set
  of heap blocks.  In the future, we might also want to support using a parallel
  bitmap index scan to set up for a parallel bitmap heap scan, but that's a job
  for another day.  Dilip Kumar, with some corrections and cosmetic changes by
  me.  The larger patch set of which this is a part has been reviewed and tested
  by (at least) Andres Freund, Amit Khandekar, Tushar Ahuja, Rafia Sabih,
  Haribabu Kommi, Thomas Munro, and me.  Discussion:

- Add a Gather Merge executor node.  Like Gather, we spawn multiple workers and
  run the same plan in each one; however, Gather Merge is used when each worker
  produces the same output ordering and we want to preserve that output ordering
  while merging together the streams of tuples from various workers.  (In a way,
  Gather Merge is like a hybrid of Gather and MergeAppend.) This works out to a
  win if it saves us from having to perform an expensive Sort.  In cases where
  only a small amount of data would need to be sorted, it may actually be faster
  to use a regular Gather node and then sort the results afterward, because
  Gather Merge sometimes needs to wait synchronously for tuples whereas a pure
  Gather generally doesn't.  But if this avoids an expensive sort then it's a
  win.  Rushabh Lathia, reviewed and tested by Amit Kapila, Thomas Munro, and
  Neha Sharma, and reviewed and revised by me.  Discussion:

- Fix a couple of planner bugs in Gather Merge.  Neha Sharma reported these to
  Rushabh Lathia just after I commit 355d3993c53ed62c5b53d020648e4fbcfbf5f155
  went in.  The patch is Rushabh's, with input from me.

- Fix bug in parallel tidbitmap iteration.  Avoid computing
  idxpages[istate->spageptr] until after checking that istate->spageptr is a
  legal index.  Dilip Kumar, per a report from David Rowley Discussion:

- Document some new parallel query capabilities.  This updates the text for
  parallel index scan, parallel index-only scan, parallel bitmap heap scan, and
  parallel merge join.  It also expands the discussion of parallel joins
  slightly.  Discussion:

- Document lack of validation when attaching foreign partitions.  Ashutosh
  Bapat, revised a bit by me.  Discussion:

- Use group updates when setting transaction status in clog.  Commit
  0e141c0fbb211bdd23783afa731e3eef95c9ad7a introduced a mechanism to reduce
  contention on ProcArrayLock by having a single process clear XIDs in the
  procArray on behalf of multiple processes, reducing the need to hand the lock
  around.  Use a similar mechanism to reduce contention on CLogControlLock.
  Testing shows that this very significantly reduces the amount of time waiting
  for CLogControlLock on high-concurrency pgbench tests run on a large
  multi-socket machines; whether that translates into a TPS improvement depends
  on how much of that contention is simply shifted to some other lock,
  particularly WALWriteLock.  Amit Kapila, with some cosmetic changes by me.
  Extensively reviewed, tested, and benchmarked over a period of about 15 months
  by Simon Riggs, Robert Haas, Andres Freund, Jesper Pedersen, and especially by
  Tomas Vondra and Dilip Kumar.  Discussion:

- Throw an error if a DATA() line contains wrong # of attributes.  David
  Christensen, reviewed by Dagfinn Ilmari Mannsåker Discussion:

- Revert "Use group updates when setting transaction status in clog.".  This
  reverts commit ccce90b398673d55b0387b3de66639b1b30d451b.  This optimization is
  unsafe, at least, of rollbacks and rollbacks to savepoints, but I'm concerned
  there may be other problematic cases as well.  Therefore, I've decided to
  revert this pending further investigation.

Tom Lane pushed:

- Avoid dangling pointer to relation name in RLS code path in DoCopy().  With
  RLS active, "COPY tab TO ..." failed under -DRELCACHE_FORCE_RELEASE, and would
  sometimes fail without that, because it used the relation name directly from
  the relcache as part of the parsetree it's building.  That becomes a
  potentially-dangling pointer as soon as the relcache entry is closed, a bit
  further down.  Typical symptom if the relcache entry chanced to get cleared
  would be "relation does not exist" error with a garbage relation name, or
  possibly a core dump; but if you were really truly unlucky, the COPY might
  copy from the wrong table.  Per report from Andrew Dunstan that regression
  tests fail with -DRELCACHE_FORCE_RELEASE.  The core tests now pass for me (but
  have not tried "make check-world" yet).  Discussion:

- Repair incorrect pg_dump labeling for some comments and security labels.  We
  attached no schema label to comments for procedural languages, casts,
  transforms, operator classes, operator families, or text search objects.  The
  first three categories of objects don't really have schemas, but pg_dump
  treats them as if they do, and it seems like the TocEntry fields for their
  comments had better match the TocEntry fields for the parent objects.  (As an
  example of a possible hazard, the type names in a CAST will be formatted with
  the assumption of a particular search_path, so failing to ensure that this
  same path is active for the COMMENT ON command could lead to an error or to
  attaching the comment to the wrong cast.) In the last six cases, this was a
  flat-out error --- possibly mine to begin with, but it was a long time ago.
  The security label for a procedural language was likewise not correctly
  labeled as to schema, and both the comment and security label for a procedural
  language were not correctly labeled as to owner.  In simple cases the restore
  would accidentally work correctly anyway, since these comments and security
  labels would normally get emitted right after the owning object, and so the
  search path and active user would be correct anyhow.  But it could fail in
  corner cases; for example a schema-selective restore would omit comments it
  should include.  Giuseppe Broccolo noted the oversight, and proposed the
  correct fix, for text search dictionary objects; I found the rest by
  cross-checking other dumpComment() calls.  These oversights are ancient, so
  back-patch all the way.  Discussion:

- Remove vestigial grammar support for CHARACTER ... CHARACTER SET option.  The
  SQL standard says that you should be able to write "CHARACTER SET foo" as part
  of the declaration of a char-type column.  We don't implement that, but a
  rough form of support has existed in gram.y since commit f10b63923.  That's
  now sat there for nigh 20 years without anyone fleshing it out --- and even if
  someone did, the contemplated approach of having separate data type name(s)
  for every character set certainly isn't what we'd do today.  Let's just remove
  the grammar production; if anyone is ever motivated to work on this,
  reinventing the grammar support is a trivial fraction of what they'd have to
  do.  And we've never documented anything about supporting such a clause.  Per
  gripe from Neha Khatri.  Discussion:

- Fix pgbench's failure to honor the documented long-form option "--builtin".
  Not only did it not accept --builtin as a synonym for -b, but what it did
  accept as a synonym was --tpc-b (huh?), which it got even further wrong by
  marking as no_argument, so that if you did try that you got a core dump.  I
  suppose this is leftover from some early design for the new switches added by
  commit 8bea3d221, but it's still pretty sloppy work.  Per bug #14580 from
  Stepan Pesternikov.  Back-patch to 9.6 where the error was introduced.

- Clean up test_ifaddrs a bit.  We customarily #include <netinet/in.h> before
  <arpa/inet.h>; according to our git history (cf commit 527f8babc) there used
  to be platform(s) where <arpa/inet.h> didn't compile otherwise.  That's
  probably not really an issue anymore, but since test_ifaddrs.c is the one and
  only place in our code that's not following that rule, bring it into line.
  Also remove #include <sys/socket.h>, as that's duplicative given that
  libpq/ifaddr.h does so (via pqcomm.h).  In passing, add a .gitignore file so
  nobody accidentally commits the test_ifaddrs executable, as I nearly did.  I
  see no particular need to back-patch this, as it's just neatnik-ism
  considering we don't build test_ifaddrs by default, or even document it

- Invent start_proc parameters for PL/Tcl.  Define GUCs pltcl.start_proc and
  pltclu.start_proc.  When set to a nonempty value at the time a new Tcl
  interpreter is created, the parameterless pltcl or pltclu function named by
  the GUC is called to allow user-controlled initialization to occur within the
  interpreter.  This is modeled on plv8's start_proc parameter, and also has
  much in common with plperl's on_init feature.  It allows users to fully
  replace the "modules" feature that was removed in commit 817f2a586.  Since an
  initializer function could subvert later Tcl code in nearly arbitrary ways,
  mark both GUCs as SUSET for now.  It would be nice to find a way to relax that
  someday; but the corresponding GUCs in plperl are also SUSET, and there's not
  been much complaint.  Discussion:

- Silence compiler warnings in tbm_prepare_shared_iterate().  Maybe Robert's
  compiler can convince itself that these variables are never used
  uninitialized, but mine can't.

- Use doubly-linked block lists in aset.c to reduce large-chunk overhead.  Large
  chunks (those too large for any palloc freelist) are managed as separate
  blocks.  Formerly, realloc'ing or pfree'ing such a chunk required O(N) time in
  a context with N blocks, since we had to traipse down the singly-linked block
  list to locate the block's predecessor before we could fix the list links.
  This can result in O(N^2) runtime in situations where large numbers of such
  chunks are manipulated within one context.  Cases like that were not foreseen
  in the original design of aset.c, and indeed didn't arise until fairly
  recently.  But such problems can now occur in reorderbuffer.c and in hash
  joining, both of which make repeated large requests without scaling up their
  request size as they do so, and which will free their requests in
  not-necessarily-LIFO order.  To fix, change the block list from singly-linked
  to doubly-linked.  This adds another 4 or 8 bytes to ALLOC_BLOCKHDRSZ, but
  that doesn't seem like unacceptable overhead, since aset.c's blocks are
  normally 8K or more, and never less than 1K in current practice.  In passing,
  get rid of some redundant AllocChunkGetPointer() calls in AllocSetRealloc (the
  compiler might be smart enough to optimize these away anyway, but no need to
  assume that) and improve AllocSetCheck's checking of block header fields.
  Back-patch to 9.4 where reorderbuffer.c appeared.  We could take this further
  back, but currently there's no evidence that it would be useful.  Discussion:

- Silence compiler warnings in BitmapHeapNext().  Same disease as

- Put back <float.h> in a few files that need it for _isnan().  Further fallout
  from commit c29aff959: there are some files that need <float.h>, and were
  getting it from datatype/timestamp.h, but it was not apparent in my (tgl's)
  testing because the requirement for <float.h> exists only on certain Windows
  toolchains.  Report and patch by David Rowley.  Discussion:

- Suppress compiler warning in non-USE_LIBXML builds.  Compilers that don't
  realize that ereport(ERROR) doesn't return complained that XmlTableGetValue()
  failed to return a value.  Also, make XmlTableFetchRow's non-USE_LIBXML case
  look more like the other ones.  As coded, it could lead to "unreachable code"
  warnings with USE_LIBXML enabled.  Oversights in commit fcec6caaf.  Per

- Suppress compiler warning in slab.c.  Compilers that don't realize that
  elog(ERROR) doesn't return complained that SlabRealloc() failed to return a
  value.  While at it, fix the rather muddled header comment for the function.
  Per buildfarm.

- Document intentional violations of header inclusion policy.  Although there
  are good reasons for our policy of including postgres.h as the first #include
  in every .c file, never from .h files, there are two places where it seems
  expedient to violate the policy because the alternative is to modify
  externally-supplied .c files.  (In the case of the regexp library, the idea
  that it's externally-supplied is kind of at odds with reality, but I haven't
  entirely given up hope that it will become a standalone project some day.)
  Add some comments to make it explicit that this is a policy violation and
  provide the reasoning.  In passing, move #include "miscadmin.h" out of
  regcomp.c and into regcustom.h, which is where it should be if we're taking
  this reasoning seriously at all.  Discussion:

- Bring plpgsql into line with header inclusion policy.  We have a project
  policy that every .c file should start by including postgres.h, postgres_fe.h,
  or c.h as appropriate; and then there is no need for any .h file to explicitly
  include any of these.  (The core reason for this policy is to make it easy to
  verify that pg_config_os.h is included before any system headers such as
  <stdio.h>; without that, we have portability issues on some platforms due to
  variation in largefile options across different modules in the backend.  Also,
  if .h files were responsible for choosing which of these key headers to
  include, .h files that need to be includable in either frontend or backend
  compiles would be in trouble.) plpgsql was blithely ignoring this policy, so
  whack it upside the head until it complies.  I also chose to standardize on
  including plpgsql's own .h files after all core-system headers that it pulls
  in.  That could've been done either way, but this way seems saner.

- Fix inclusions of postgres_fe.h from .h files.  We have a project policy that
  every .c file should start by including postgres.h, postgres_fe.h, or c.h as
  appropriate; and then there is no need for any .h file to explicitly include
  any of these.  Fix a few headers that were violating this policy by including
  postgres_fe.h.  Discussion:

- Fix inclusions of c.h from .h files.  We have a project policy that every .c
  file should start by including postgres.h, postgres_fe.h, or c.h as
  appropriate; and then there is no need for any .h file to explicitly include
  any of these.  Fix a few headers that were violating this policy by including
  c.h.  Discussion:

- Fix timestamptz regression test to still work with latest IANA zone data.  The
  IANA timezone crew continues to chip away at their project of removing
  timezone abbreviations that have no real-world currency from their database.
  The tzdata2017a update removes all such abbreviations for South American
  zones, as well as much of the Pacific.  This breaks some test cases in
  timestamptz.sql that were expecting America/Santiago and America/Caracas to
  have non-numeric abbreviations.  The test cases involving America/Santiago
  seem to have selected that zone more or less at random, so just replace it
  with America/New_York, which is of similar longitude.  The cases involving
  America/Caracas are harder since they were chosen to test a time-varying zone
  abbreviation around a point where it changed meaning in the backwards
  direction.  Fortunately, Europe/Moscow has a similar case in 2014, and the
  MSK/MSD abbreviations are well enough attested that IANA seems unlikely to
  decide to remove them from the database in future.  With these changes, this
  regression test should pass when using any IANA zone database from 2015 or
  later.  One could wish that there were a few years more daylight on how
  out-of-date your zone database can be ... but really the --with-system-tzdata
  option is only meant for use on platforms where the zone database is kept
  up-to-date pretty faithfully, so I do not think this is a big objection.

- Fix hard-coded relkind constants in pg_dump.c.  Although it's reasonable to
  expect that most of these constants will never change, that does not make it
  good programming style to hard-code the value rather than using the
  RELKIND_FOO macros.  There were only a few such violations, and all relatively
  new AFAICT.  Existing style is mostly to inject relkind values into
  constructed query strings using %c.  I did not bother to touch places that did
  it like that, but really a better technique is to stringify the RELKIND macro,
  at least in places where you'd want single quotes around the code character.
  That avoids any runtime effort and keeps the RELKIND symbol close to where
  it's used.  Discussion:

- Make CppAsString2() more visible in c.h.  For some reason this standard C
  string-processing hack was buried in an NLS-related section of c.h.  Put it
  beside CppAsString() so that people are more likely to find it and not be
  tempted to reinvent local copies, as I nearly did.  And provide a more helpful
  comment, too.

- Fix hard-coded relkind constants in psql/describe.c.  Although it's reasonable
  to expect that most of these constants will never change, that does not make
  it good programming style to hard-code the value rather than using the
  RELKIND_FOO macros.  Discussion:

- Fix portability problem in  Commit 7666e73a2 introduced a
  dependency on filehandles' input_line_number method, but apparently that's a
  Perl neologism.  Use $. instead, which works at least back to Perl 5.10, and
  hopefully back to 5.8.  Jeff Janes Discussion:

- Fix hard-coded relkind constants in assorted src/bin files.  Although it's
  reasonable to expect that most of these constants will never change, that does
  not make it good programming style to hard-code the value rather than using
  the RELKIND_FOO macros.  Discussion:

- Add .gitignore to contrib/amcheck.  Oversight in commit 3717dc149.

- Fix hard-coded relkind constants in assorted other files.  Although it's
  reasonable to expect that most of these constants will never change, that does
  not make it good programming style to hard-code the value rather than using
  the RELKIND_FOO macros.  I think I've now gotten all the hard-coded references
  in C code.  Unfortunately there's no equally convenient way to parameterize
  SQL files ...  Discussion:

- Un-break things on IPv6-less platforms.  Commit be37c2120 forgot to teach
  initdb about commenting out the IPv6 replication entry that it caused to exist
  in pg_hba.conf.sample.  Per buildfarm.

- Change the relkind for partitioned tables from 'P' to 'p'.  Seven of the eight
  other relkind codes are lower-case, so it wasn't consistent for this one to be
  upper-case.  Fix it while we still can.  Historical notes: the reason for the
  lone exception, i.e. sequences being 'S', is that 's' was once used for
  "special" relations.  Also, at one time the partitioned-tables patch used both
  'P' and 'p', but that got changed, leaving only a surprising choice behind.
  This also fixes a couple little bits of technical debt, such as
  type_sanity.sql not knowing that 'm' is a legal value for relkind.

- Sanitize newlines in object names in "pg_restore -l" output.  Commits
  89e0bac86 et al replaced newlines with spaces in object names printed in SQL
  comments, but we neglected to consider that the same names are also printed by
  "pg_restore -l", and a newline would render the output unparseable by
  "pg_restore -L".  Apply the same replacement in "-l" output.  Since
  "pg_restore -L" doesn't actually examine any object names, only the dump ID
  field that starts each line, this is enough to fix things for its purposes.
  The previous fix was treated as a security issue, and we might have done that
  here as well, except that the issue was reported publicly to start with.
  Anyway it's hard to see how this could be exploited for SQL injection;
  "pg_restore -L" doesn't do much with the file except parse it for leading
  integers.  Per bug #14587 from Milos Urbanek.  Back-patch to all supported
  versions.  Discussion:

- Reduce log verbosity of startup/shutdown for launcher subprocesses.  There's
  no really good reason why the autovacuum launcher and logical replication
  launcher should announce themselves at startup and shutdown by default.  Users
  don't care that those processes exist, and it's inconsistent that those
  background processes announce themselves while others don't.  So, reduce those
  messages from LOG to DEBUG1 level.  I was sorely tempted to reduce the
  "starting logical replication worker for subscription ..." message to DEBUG1
  as well, but forebore for now.  Those processes might possibly be of direct
  interest to users, at least until logical replication is a lot better shaken
  out than it is today.  Discussion:

- contrib/amcheck needs RecentGlobalXmin to be PGDLLIMPORT'ified.  Per
  buildfarm.  Maybe some of the other xmin variables in snapmgr.h ought to get
  this too, but for the moment I'm just interested in un-breaking the buildfarm.

- Improve postmaster's logging of listen socket creation.  When one of the
  kernel calls in the socket()/bind()/listen() sequence fails, include the
  specific address we're trying to bind to in the log message.  This greatly
  eases debugging of network misconfigurations.  Also, after successfully
  setting up a listen socket, report its address in the log, to ease
  verification that the expected addresses were bound.  There was some debate
  about whether to print this message at LOG level or only DEBUG1, but the
  majority of votes were for the former.  Discussion:

- Add a "subtransaction" command to PL/Tcl.  This allows rolling back the
  effects of some SPI commands without having to fail the entire PL/Tcl
  function.  Victor Wagner, reviewed by Pavel Stehule Discussion:

Stephen Frost pushed:

- pg_upgrade: Fix large object COMMENTS, SECURITY LABELS.  When performing a
  pg_upgrade, we copy the files behind pg_largeobject and
  pg_largeobject_metadata, allowing us to avoid having to dump out and reload
  the actual data for large objects and their ACLs.  Unfortunately, that isn't
  all of the information which can be associated with large objects.  Currently,
  we also support COMMENTs and SECURITY LABELs with large objects and these were
  being silently dropped during a pg_upgrade as pg_dump would skip everything
  having to do with a large object and pg_upgrade only copied the tables
  mentioned to the new cluster.  As the file copies happen after the catalog
  dump and reload, we can't simply include the COMMENTs and SECURITY LABELs in
  pg_dump's binary-mode output but we also have to include the actual large
  object definition as well.  With the definition, comments, and security labels
  in the pg_dump output and the file copies performed by pg_upgrade, all of the
  data and metadata associated with large objects is able to be successfully
  pulled forward across a pg_upgrade.  In 9.6 and master, we can simply adjust
  the dump bitmask to indicate which components we don't want.  In 9.5 and
  earlier, we have to put explciit checks in in dumpBlob() and dumpBlobs() to
  not include the ACL or the data when in binary-upgrade mode.  Adjustments made
  to the privileges regression test to allow another test (large_object.sql) to
  be added which explicitly leaves a large object with a comment in place to
  provide coverage of that case with pg_upgrade.  Back-patch to all supported
  branches.  Discussion:

- pg_dump: Properly handle public schema ACLs with --clean.  pg_dump has always
  handled the public schema in a special way when it comes to the "--clean"
  option.  To wit, we do not drop or recreate the public schema in "normal"
  mode, but when we are run in "--clean" mode then we do drop and recreate the
  public schema.  When running in "--clean" mode, the public schema is dropped
  and then recreated and it is recreated with the normal schema-default
  privileges of "nothing".  This is unlike how the public schema starts life,
  which is to have CREATE and USAGE GRANT'd to the PUBLIC role, and that is what
  is recorded in pg_init_privs.  Due to this, in "--clean" mode, pg_dump would
  mistakenly only dump out the set of privileges required to go from the
  initdb-time privileges on the public schema to whatever the current-state
  privileges are.  If the privileges were not changed from initdb time, then no
  privileges would be dumped out for the public schema, but with the schema
  being dropped and recreated, the result was that the public schema would have
  no ACLs on it instead of what it should have, which is the initdb-time
  privileges.  Practically speaking, this meant that pg_dump with --clean mode
  dumping a database where the ACLs on the public schema were not changed from
  the default would, upon restore, result in a public schema with *no*
  privileges GRANT'd, not matching the state of the existing database (where the
  initdb-time privileges would have been CREATE and USAGE to the PUBLIC role for
  the public schema).  To fix, adjust the query in getNamespaces() to ignore the
  pg_init_privs entry for the public schema when running in "--clean" mode,
  meaning that the privileges for the public schema would be dumped, correctly,
  as if it was going from a newly-created schema to the current state (which is,
  indeed, what will happen during the restore thanks to the DROP/CREATE).  Only
  the public schema is handled in this special way by pg_dump, no other
  initdb-time objects are dropped/recreated in --clean mode.  Back-patch to 9.6
  where the bug was introduced.  Discussion:

- psql: Add \gx command.  It can often be useful to use expanded mode output
  (\x) for just a single query.  Introduce a \gx which acts exactly like \g
  except that it will force expanded output mode for that one \gx call.  This is
  simpler than having to use \x as a toggle and also means that the user doesn't
  have to worry about the current state of the expanded variable, or resetting
  it later, to ensure a given query is always returned in expanded mode.
  Primairly Christoph's patch, though I did tweak the documentation and help
  text a bit, and re-indented the tab completion section.  Author: Christoph
  Berg Reviewed By: Daniel Verite Discussion:

- Expose explain's SUMMARY option.  This exposes the existing explain summary
  option to users to allow them to choose if they wish to have the planning time
  and totalled run time included in the EXPLAIN result.  The existing default
  behavior is retained if SUMMARY is not specified- running explain without
  analyze will not print the summary lines (just the planning time, currently)
  while running explain with analyze will include the summary lines (both the
  planning time and the totalled execution time).  Users who wish to see the
  summary information for plain explain can now use: EXPLAIN (SUMMARY ON) query;
  Users who do not want to have the summary printed for an analyze run can use:
  EXPLAIN (ANALYZE ON, SUMMARY OFF) query; With this, we can now also have
  EXPLAIN ANALYZE queries included in our regression tests by using: EXPLAIN
  (ANALYZE ON, TIMING OFF, SUMMARY off) query; I went ahead and added an example
  of this, which will hopefully not make the buildfarm complain.  Author:
  Ashutosh Bapat Discussion:

- Add relkind checks to certain contrib modules.  The contrib extensions
  pageinspect, pg_visibility and pgstattuple only work against regular relations
  which have storage.  They don't work against foreign tables, partitioned
  (parent) tables, views, et al.  Add checks to the user-callable functions to
  return a useful error message to the user if they mistakenly pass an invalid
  relation to a function which doesn't accept that kind of relation.  In
  passing, improve some of the existing checks to use ereport() instead of
  elog(), add a function to consolidate common checks where appropriate, and add
  some regression tests.  Author: Amit Langote, with various changes by me
  Reviewed by: Michael Paquier and Corey Huinker Discussion:

- pgstattuple: Fix typo partitiond -> partitioned.  Pointed out by Michael

Andres Freund pushed:

- Make simplehash.h grow hashtable in additional cases.  Increase the size when
  either the distance between actual and optimal slot grows too large, or when
  too many subsequent entries would have to be moved.  This addresses reports
  that the simplehash performed, sometimes considerably, worse than dynahash.
  The reason turned out to be that insertions into the hashtable where, due to
  the use of parallel query, in effect done from another hashtable, in
  hash-value order.  If the target hashtable, due to mis-estimation, was sized a
  lot smaller than the source table(s) that lead to very imbalanced tables; a
  lot of entries in many close-by buckets from the source tables were inserted
  into a single, wider, bucket on the target table.  As the growth factor was
  solely computed based on the fillfactor, the performance of the table
  decreased further and further.  b81b5a96f424531b was an attempt to address
  this problem for hash aggregates (but not for bitmap scans), but it turns out
  that the current method of mixing hash values often actually leaves
  neighboring hash-values close to each other, just in different value range.
  It might be worth revisiting that independently of the performance issues
  addressed in this patch..  To address that problem resize tables in two
  additional cases: Firstly when the optimal position for an entry would be far
  from the actual position, secondly when many entries would have to be moved to
  make space for the new entry (while satisfying the robin hood property).  Due
  to the additional resizing threshold it seems possible, and testing confirms
  that so far, that a higher fillfactor doesn't hurt performance and saves a bit
  of memory.  It seems better to increase it now, before a release containing
  any of this code, rather than wonder in some later release.  The various
  boundaries aren't determined in a particularly scientific manner, they might
  need some fine-tuning.  In all my tests the new code now, even with
  parallelism, performs at least as good as the old code, in several scenarios
  significantly better.  Reported-By: Dilip Kumar, Robert Haas, Kuntal Ghosh

- Add amcheck extension to contrib.  This is the beginning of a collection of
  SQL-callable functions to verify the integrity of data files.  For now it only
  contains code to verify B-Tree indexes.  This adds two SQL-callable functions,
  validating B-Tree consistency to a varying degree.  Check the, extensive, docs
  for details.  The goal is to later extend the coverage of the module to
  further access methods, possibly including the heap.  Once checks for
  additional access methods exist, we'll likely add some "dispatch" functions
  that cover multiple access methods.  Author: Peter Geoghegan, editorialized by
  Andres Freund Reviewed-By: Andres Freund, Tomas Vondra, Thomas Munro,
  Anastasia Lubennikova, Robert Haas, Amit Langote Discussion:

- amcheck: editorialize variable name & comment.  No exclusive lock is taken

- Enable 64 bit atomics on ARM64.  Previously they were disabled due to
  performance concerns on 32bit arm, where 64bit atomics are often implemented
  via kernel traps.  Author: Roman Shaposhnik Discussion:

- Improve expression evaluation test coverage.  Upcoming patches are revamping
  expression evaluation significantly. It therefore seems prudent to try to
  ensure that the coverage of the existing evaluation code is high.  This commit
  adds coverage for the cases that can reasonably be tested. There's still a
  bunch of unreachable error messages and such, but otherwise this achieves
  nearly full regression test coverage (with the exception of the unused
  GetAttributeByNum/GetAttributeByName).  Author: Andres Freund Discussion:

Heikki Linnakangas pushed:

- Refactor SHA2 functions and move them to src/common/.  This way both frontend
  and backends can use them. The functions are taken from pgcrypto, which now
  fetches the source files it needs from src/common/.  A new interface is
  designed for the SHA2 functions, which allow linking to either OpenSSL or the
  in-core stuff taken from KAME as needed.  Michael Paquier, reviewed by Robert
  Haas.  Discussion:

- Add regression tests for passwords.  Michael Paquier.

- Fix comments in SCRAM-SHA-256 patch.  Amit Kapila.

- Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).  This introduces a
  new generic SASL authentication method, similar to the GSS and SSPI methods.
  The server first tells the client which SASL authentication mechanism to use,
  and then the mechanism-specific SASL messages are exchanged in
  AuthenticationSASLcontinue and PasswordMessage messages. Only SCRAM-SHA-256 is
  supported at the moment, but this allows adding more SASL mechanisms in the
  future, without changing the overall protocol.  Support for channel binding,
  aka SCRAM-SHA-256-PLUS is left for later.  The SASLPrep algorithm, for
  pre-processing the password, is not yet implemented. That could cause trouble,
  if you use a password with non-ASCII characters, and a client library that
  does implement SASLprep.  That will hopefully be added later.  Authorization
  identities, as specified in the SCRAM-SHA-256 specification, are ignored. SET
  SESSION AUTHORIZATION provides more or less the same functionality, anyway.
  If a user doesn't exist, perform a "mock" authentication, by constructing an
  authentic-looking challenge on the fly. The challenge is derived from a new
  system-wide random value, "mock authentication nonce", which is created at
  initdb, and stored in the control file. We go through these motions, in order
  to not give away the information on whether the user exists, to
  unauthenticated users.  Bumps PG_CONTROL_VERSION, because of the new field in
  control file.  Patch by Michael Paquier and Heikki Linnakangas, reviewed at
  different stages by Robert Haas, Stephen Frost, David Steele, Aleksander
  Alekseev, and many others.  Discussion:

- A collection of small fixes for the SCRAM patch.  * Add required #includes for
  htonl. Per buildfarm members pademelon/gaur.  * Remove unnecessary "#include
  <utils/memutils>".  * Fix checking for empty string in pg_SASL_init. (Reported
  by Peter Eisentraut and his compiler) * Move code in pg_SASL_init to match the
  recent changes (commit ba005f193d) to pg_fe_sendauth() function, where it's
  copied from.  * Return value of malloc() was not checked for NULL in
  scram_SaltedPassword(). Fix by avoiding the malloc().

Magnus Hagander pushed:

- Fix grammar.  Reported by Jeremy Finzel

Fujii Masao pushed:

- Fix connection leak in DROP SUBSCRIPTION command, take 2.  Commit
  898a792eb8283e31efc0b6fcbc03bbcd5f7df667 fixed the connection leak issue, but
  it was an unreliable way of bugfix. This bugfix was assuming that
  walrcv_command() subroutine cannot throw an error, but it's untenable
  assumption. For example, if it will be changed so that an error is thrown,
  connection leak issue will happen again.  This patch ensures that the
  connection is closed even when walrcv_command() subroutine throws an error.
  Patch by me, reviewed by Petr Jelinek and Michael Paquier Discussion:

- Prevent logical rep workers with removed subscriptions from starting.  Any
  logical rep workers must have their subscription entries in pg_subscription.
  To ensure this, we need to prevent the launcher from starting new worker
  corresponding to the subscription that DROP SUBSCRIPTION command is removing.
  To implement this, previously LogicalRepLauncherLock was introduced and held
  until the end of transaction running DROP SUBSCRIPTION. But using LWLock for
  that purpose was not valid.  Instead, this commit changes DROP SUBSCRIPTION so
  that it takes AccessExclusiveLock on pg_subscription, in order to ensure that
  the launcher cannot see any subscriptions being removed. Also this commit gets
  rid of LogicalRepLauncherLock.  Patch by me, reviewed by Petr Jelinek

Álvaro Herrera pushed:

- Support XMLTABLE query expression.  XMLTABLE is defined by the SQL/XML
  standard as a feature that allows turning XML-formatted data into relational
  form, so that it can be used as a <table primary> in the FROM clause of a
  query.  This new construct provides significant simplicity and performance
  benefit for XML data processing; what in a client-side custom implementation
  was reported to take 20 minutes can be executed in 400ms using XMLTABLE.  (The
  same functionality was said to take 10 seconds using nested PostgreSQL XPath
  function calls, and 5 seconds using XMLReader under PL/Python).  The
  implemented syntax deviates slightly from what the standard requires.  First,
  the standard indicates that the PASSING clause is optional and that multiple
  XML input documents may be given to it; we make it mandatory and accept a
  single document only.  Second, we don't currently support a default namespace
  to be specified.  This implementation relies on a new executor node based on a
  hardcoded method table.  (Because the grammar is fixed, there is no
  extensibility in the current approach; further constructs can be implemented
  on top of this such as JSON_TABLE, but they require changes to core code.)
  Author: Pavel Stehule, Álvaro Herrera Extensively reviewed by: Craig Ringer

- Fix XMLTABLE on older libxml2.  libxml2 older than 2.9.1 does not have
  xmlXPathSetContextNode (released in 2013, so reasonable platforms have
  trouble).  That function is fairly trivial, so I have inlined it in the one
  added caller.  This passes tests on my machine; let's see what the buildfarm
  thinks about it.  Per joint complaint from Tom Lane and buildfarm.

Michael Meskes pushed:

- Fix a potential double-free in ecpg.

Joe Conway pushed:

- Fix ancient connection leak in dblink.  When using unnamed connections with
  dblink, every time a new connection is made, the old one is leaked. Fix that.
  This has been an issue probably since dblink was first committed.  Someone
  complained almost ten years ago, but apparently I decided not to pursue it at
  the time, and neither did anyone else, so it slipped between the cracks. Now
  that someone else has complained, fix in all supported branches.  Discussion:
  Discussion: (new)
  Reported by: Jim Nasby and Takayuki Tsunakawa

== Pending Patches ==

Jim Nasby sent in another revision of a patch to add SPI_execute_callback() and
a callback-based DestReceiver, and modify plpython to use same.

Etsuro Fujita, Ashutosh Bapat, and David Rowley traded patches to fix an issue
where foreign Join pushdowns were not working properly for outer joins.

Amit Langote sent in two more revisions of a patch to avoid creating scan nodes
for partitioned tables and not allocate storage for partitioned tables.

Kyotaro HORIGUCHI sent in another revision of a patch to use a radix tree for
character conversion.

Kyotaro HORIGUCHI sent in another revision of a patch to fix some infelicities
between logical replication and database encoding.

Masahiko Sawada sent in a patch to update the documentation to reflect the fact
that oldestxmin is now shown in VACUUM.

Dagfinn Ilmari Mannsåker sent in another revision of a patch to fix many
perlcritic exceptions.

Kyotaro HORIGUCHI sent in a patch to add a WAL relief vent for replication

Takeshi Ideriha sent in another revision of a patch to add DECLARE STATEMENT to

Petr Jelínek sent in a patch to logical replication apply to run with sync
commit off by default.

Robert Haas sent in a patch to fix the computation of parallel workers to
distinguish "can't have a heap page" from "found zero heap pages."

Kyotaro HORIGUCHI sent in another revision of a patch to remove

Masahiko Sawada sent in another revision of a patch to add a GUC for cleanup
indexes threshold.

Thomas Munro sent in two more revisions of a patch to add a [parallel [shared]]

Aleksander Alekseev sent in three more revisions of a patch to make declarative
partitioning work faster when large numbers of partitions are present.

Masahiko Sawada sent in another revision of a patch to report the number of
skipped frozen pages by manual VACUUM.

David Steele sent in another revision of a patch to add a configurable file mode

Amos Bird sent in a patch to make psql show indexes with type info.

Andreas Karlsson sent in a patch to rename the default log directory from pg_log
to log.

Petr Jelínek and Peter Eisentraut traded patches to allow enable an existing
data copy for logical replication.

Andres Freund sent in another revision of a patch to speed up expression

Jan Michálek sent in another revision of a patch to allow formatting tables in
psql as markdown, mediawiki, and rst.

Masahiko Sawada sent in another revision of a patch to allow transactions across
foreign tables.

Masahiko Sawada sent in a patch to document the fact that PREPARE TRANSACTION is
now part of ECPG.

Simon Riggs and Dean Rasheed traded patches to speed up replay of

Tomas Vondra sent in another revision of a patch to implement two slab-like
memory allocators.

David Rowley sent in a patch to fix some warnings in the slab-like memory
allocators patch.

Haribabu Kommi sent in another revision of a patch to refactor handling of
database attributes between pg_dump and pg_dumpall.

Haribabu Kommi sent in another revision of a patch to implement a pg_stat_sql

Pavan Deolasee sent in another revision of a patch to skip all-visible pages
during second HeapScan of CREATE INDEX CONCURRENTLY.

Michaël Paquier sent in another revision of a patch to implement SASLprep.

Ivan Kartyshov sent in two more revisions of a patch to make async slave to wait
for lsn to be replayed.

Michaël Paquier sent in two revisions of a patch to add clause PASSWORD (val

Rafia Sabih and Robert Haas traded patches to enable parallelism for queries
coming from SQL or other PL functions.

Daniel Vérité and Vaishnavi Prabakaran traded patches to add batch/pipelining
support for libpq.

Takayuki Tsunakawa sent in a patch to refactor strinfo in dblink.

Daniel Vérité and Vaishnavi Prabakaran traded patches to add batch/pipelining
support for libpq.

Takayuki Tsunakawa sent in a patch to refactor strinfo in dblink.

Amit Khandekar sent in two more revisions of a patch to implement parallel

Kevin Grittner sent in two more revisions of a patch to add transition table
support for, among other things, statement triggers and materialized view

Kuntal Ghosh sent in another revision of a patch to add WAL consistency check
support for hash indexes.

Andrew Gierth sent in two more revisions of a patch to add hash support for
grouping sets.

Takayuki Tsunakawa sent in another revision of a patch to support huge pages on

Craig Ringer sent in a patch to fix an off-by-one error in logical slot resource

Rushabh Lathia sent in another revision of a patch to add wait events for disk

Amit Langote sent in a patch to use ALTER FOREIGN TABLE with foreign table in

Álvaro Herrera sent in another revision of a patch to add WARM.

Victor Wagner sent in three more revisions of a patch to add explicit
subtransactions for PL/Tcl.

Peter Eisentraut sent in another revision of a patch to cast result of
copyObject() to correct type.

Peter Eisentraut sent in another revision of a patch to implement ICU

Amit Langote sent in another revision of a patch to fix an infelicity between
declarative partitioning and ON CONFLICT.

Amit Langote sent in another revision of a patch to improve the documents on
declarative partitioning.

Amit Langote sent in a patch to fix a bug in get_partition_for_tuple.

Peter Geoghegan sent in a patch to fix the amcheck build on Windows.

Petr Jelínek sent in a patch to fix remote position tracking in logical

Kuntal Ghosh sent in another revision of a patch to expose wait events for

Beena Emerson sent in another revision of a patch to allow increasing the
default WAL segment size.

Vinayak Pokale sent in another revision of a patch to add an ANALYZE command
progress checker.

Michaël Paquier sent in two more revisions of a patch to fix unlogged flushes.

Surafel Temesgen and Pavel Stěhule traded patches to implement CORRESPONDING.

Tom Lane sent in two revisions of a patch to upgrade the postmaster's log
messages about bind/listen errors.

Michaël Paquier sent in a patch to change references of password encryption to

Nikita Glukhov sent in another revision of a patch to fix a bug in SP-GiST

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

Dmitry Dolgov sent in another revision of a patch to add FTS support for

Thomas Munro sent in another revision of a patch to fix SERIALIZABLE isolation
for parallel query.

Nikhil Sontakke sent in another revision of a patch to speed up two-phase

Pavel Stěhule sent in a patch to add VERBOSE_SORT_COLUMNS and

Pavel Stěhule sent in a patch to add default namespaces for XPath expressions.

Tom Lane and Andres Freund traded patches to speed up running all the tests.

Tom Lane sent in another revision of a patch to add \if and friends to psql.

Nikolay Shaplov sent in another revision of a patch to move all am-related
reloption code into src/backend/access/[am-name] and get rid of relopt_kind for
custom AM.

Stephen Frost sent in two more revisions of a patch to add macaddr 64 bit
(EUI-64) datatype support.

Peter Geoghegan sent in another revision of a patch to add parallel tuplesort
(for parallel B-Tree index creation).

pgsql-announce by date

Next:From: Daniele VarrazzoDate: 2017-03-13 11:44:21
Subject: Psycopg 2.7.1 released
Previous:From: Hiroshi SaitoDate: 2017-03-10 15:30:21
Subject: psqlODBC 09.06.0200 Released

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