|Тема:||== PostgreSQL Weekly News - December 08 2013 ==|
(см: обсуждение, исходный текст)
== PostgreSQL Weekly News - December 08 2013 == PostgreSQL 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19 bug fix releases are out. Upgrade ASAP. http://www.postgresql.org/about/news/1492/ The 7th annual "Prague PostgreSQL Developers Day" (P2D2) conference organized by CSPUG (Czech and Slovak PostgreSQL Users Group), will be held on February 6, 2014 at Faculty of Mathematics and Physics, Charles University (Malostranske namesti 25, Prague). Czech language info below. The CfP will be open throuh 2014/01/03. http://www.p2d2.cz/ The PostgreSQL Users Group in Singapore, PUGS, has assembled. For more information, see: http://www.meetup.com/PUGS-Postgres-Users-Group-Singapore/ == PostgreSQL Product News == DataFiller version 1.1.5, a random data generator for PostgreSQL based on the database schema + directives, released. https://www.cri.ensmp.fr/people/coelho/datafiller.html pg8000 1.9.0, a DB-API 2.0 compatible Pure-Python connector for PostgreSQL, released. Driver: https://pypi.python.org/pypi/pg8000/ Docs: http://pythonhosted.org/pg8000/ pg_activity 1.1.0 released. https://github.com/julmon/pg_activity/ Pyrseas 0.7.1, a toolkit for PostgreSQL version control, released. https://github.com/pyrseas/Pyrseas sqlserver2pgsql, a Perl- and Ketl-based utility for helping convert from MS-SQL Server, released. https://github.com/dalibo/sqlserver2pgsql == PostgreSQL Jobs for December == http://archives.postgresql.org/pgsql-jobs/2013-12/threads.php == PostgreSQL Local == FOSDEM PGDay, a one day conference held before FOSDEM in Brussels, Belgium, will be on Jan 31st, 2014. Details: http://fosdem2014.pgconf.eu/ CfP is closing December 15, 2013. http://fosdem2014.pgconf.eu/callforpapers/ == 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 , German language to , Italian language to . Spanish language to . == Applied Patches == Robert Haas pushed: - Avoid out-of-bounds read in errfinish if error_stack_depth < 0. If errordata_stack_depth < 0, we won't find that out and correct the problem until CHECK_STACK_DEPTH() is invoked. In the meantime, elevel will be set based on an invalid read. This is probably harmless in practice, but it seems cleaner this way. Xi Wang http://git.postgresql.org/pg/commitdiff/9d140f7be2836e3baf6c9dc7989dea69ef693532 - Make NUM_TOCHAR_prepare and NUM_TOCHAR_finish macros declare "len". Remove the variable from the enclosing scopes so that nothing can be relying on it. The net result of this refactoring is that we get rid of a few unnecessary strlen() calls. Original patch from Greg Jaskiewicz, substantially expanded by me. http://git.postgresql.org/pg/commitdiff/a8656a3ab02db5b1de0d696dc8cf588efe7c1341 - Flag mmap implemenation of dynamic shared memory as resize-capable. Error noted by Heikki Linnakangas http://git.postgresql.org/pg/commitdiff/c6d4b1dd3e9eabca68caea6256ed8bc58dfa0917 Tom Lane pushed: - Increase git_changelog's timestamp_slop from 10 min to 1 day. Many committers seem to now be using a work flow in which back-patched commits are timestamped minutes or even hours apart in different branches (most likely because they commit in one branch before starting work on the next one). git_changelog was failing to merge its reports in such cases, so increase the max time it's willing to merge commits across. I considered getting rid of the limit altogether, but that produces some odd results in terms of how the merged commit gets sorted relative to unrelated commits. http://git.postgresql.org/pg/commitdiff/7a1e34d3713c13b3b2c81f0410a6629362b37b00 - Improve draft release notes. Per suggestions from Andres Freund. Also fix spelling of Sergey Burladyan's name. http://git.postgresql.org/pg/commitdiff/b8b7b723f29e39769486545aef61d71edcadff80 - Update release notes for 9.3.2, 9.2.6, 9.1.11, 9.0.15, 8.4.19. http://git.postgresql.org/pg/commitdiff/02bb4bbc66ce2ce7ebfcb27a8a9e002ed9cadd2a - Fix crash in assign_collations_walker for EXISTS with empty SELECT list. We (I think I, actually) forgot about this corner case while coding collation resolution. Per bug #8648 from Arjen Nienhuis. http://git.postgresql.org/pg/commitdiff/7ab321404c4f721a22e86f36f68fe5e94f65e54d - Clear retry flags properly in replacement OpenSSL sock_write function. Current OpenSSL code includes a BIO_clear_retry_flags() step in the sock_write() function. Either we failed to copy the code correctly, or they added this since we copied it. In any case, lack of the clear step appears to be the cause of the server lockup after connection loss reported in bug #8647 from Valentine Gogichashvili. Assume that this is correct coding for all OpenSSL versions, and hence back-patch to all supported branches. Diagnosis and patch by Alexander Kukushkin. http://git.postgresql.org/pg/commitdiff/74242c23c1c6428c6da09fa37264c7f4f1438738 Bruce Momjian pushed: - doc: update wording of ineffective SET and ABORT commands. Wording by Alvaro Herrera http://git.postgresql.org/pg/commitdiff/54916b99f7e97aa6e32a4f265527f7517539d802 - Update C comment for pg_fe_getauthname. This function no longer takes an argument. http://git.postgresql.org/pg/commitdiff/6a6b7bbb81cd21d0f9aa70b850b791b61fb7e03d - C comment: again update comment for pg_fe_sendauth for error cases http://git.postgresql.org/pg/commitdiff/4a8adfd4d09c7885daf548ecd53d4999f168a174 - libpq: change PQconndefaults() to ignore invalid service files. Previously missing or invalid service files returned NULL. Also fix pg_upgrade to report "out of memory" for a null return from PQconndefaults(). Patch by Steve Singer, rewritten by me http://git.postgresql.org/pg/commitdiff/9e0a97f1c8316e36fa4a8626e0a60792b0fb0c2e - doc: split long query into multiple lines. Report from Erik Rijkers http://git.postgresql.org/pg/commitdiff/5043fc8251fa272177c69b86a8df2cb79d926521 - build: pass EXTRA_REGRESS_OPTS to secondary regression tests. Christoph Berg http://git.postgresql.org/pg/commitdiff/86ef4796f5120c55d1a48cfab52e51df8ed271b5 - docs: clarify SSL certificate authority chain docs. Previously, the requirements of how intermediate certificates were handled and their chain to root certificates was unclear. http://git.postgresql.org/pg/commitdiff/fa4add50c4ea97c48881fa8cb3863df80141643c - docs: update partition encryption options. Text from Adam Vande More http://git.postgresql.org/pg/commitdiff/8fe3d90d34c26083e9856cb134dfe17a5f6999aa Peter Eisentraut pushed: - doc: Refine documentation about recovery command exist status. Add more documentation about how different exit codes and signals are handled in each case. Reviewed-by: Peter Geoghegan <> http://git.postgresql.org/pg/commitdiff/95e3d50539afcdcd4b75b4ac5baa9f8fc05324d9 - Report exit code from external recovery commands properly. When an external recovery command such as restore_command or archive_cleanup_command fails, report the exit code properly, distinguishing signals and normal exists, using the existing wait_result_to_str() facility, instead of just reporting the return value from system(). Reviewed-by: Peter Geoghegan <> http://git.postgresql.org/pg/commitdiff/fef88b3fdaa3537c64e3d7df9261bc75ece80d3f - Fix whitespace http://git.postgresql.org/pg/commitdiff/dfd5151c5800448a2be521797f95e1aa63d87b67 - SSL: Add configuration option to prefer server cipher order. By default, OpenSSL (and SSL/TLS in general) lets the client cipher order take priority. This is OK for browsers where the ciphers were tuned, but few PostgreSQL client libraries make the cipher order configurable. So it makes sense to have the cipher order in postgresql.conf take priority over client defaults. This patch adds the setting "ssl_prefer_server_ciphers" that can be turned on so that server cipher order is preferred. Per discussion, this now defaults to on. From: Marko Kreen <> Reviewed-by: Adrian Klaver <> http://git.postgresql.org/pg/commitdiff/ef3267523d1ecf53bb6d4ffbeb6a0ae1af84ed47 - SSL: Support ECDH key exchange. This sets up ECDH key exchange, when compiling against OpenSSL that supports Emmanuel Cecchet. Then the ECDHE-RSA and ECDHE-ECDSA cipher suites can be used for SSL connections. The latter one means that Emmanuel Cecchet keys are now usable. The reason for Emmanuel Cecchet key exchange is that it's faster than DHE and it allows to go to higher security levels where RSA will be horribly slow. There is also new GUC option ssl_ecdh_curve that specifies the curve name used for ECDH. It defaults to "prime256v1", which is the most common curve in use in HTTPS. From: Marko Kreen <> Reviewed-by: Adrian Klaver <> http://git.postgresql.org/pg/commitdiff/3164721462d547fa2d15e2a2f07eb086a3590fd5 Heikki Linnakangas pushed: - Fix full-page writes of internal GIN pages. Insertion to a non-leaf GIN page didn't make a full-page image of the page, which is wrong. The code used to do it correctly, but was changed (commit 853d1c3103fa961ae6219f0281885b345593d101) because the redo-routine didn't track incomplete splits correctly when the page was restored from a full page image. Of course, that was not right way to fix it, the redo routine should've been fixed instead. The redo-routine was surreptitiously fixed in 2010 (commit 4016bdef8aded77b4903c457050622a5a1815c16), so all we need to do now is revert the code that creates the record to its original form. This doesn't change the format of the WAL record. Backpatch to all supported versions. http://git.postgresql.org/pg/commitdiff/22122c83f1331d03e8317afbfcfbb65bef9c82d2 - Don't include unused space in LOG_NEWPAGE records. This is the same trick we use when taking a full page image of a buffer passed to XLogInsert. http://git.postgresql.org/pg/commitdiff/9e857436ef7dff8fb8a0bf43cfe62650e2be6be9 Alvaro Herrera pushed: - Avoid resetting Xmax when it's a multi with an aborted. update HeapTupleSatisfiesUpdate can very easily "forget" tuple locks while checking the contents of a multixact and finding it contains an aborted update, by setting the HEAP_XMAX_INVALID bit. This would lead to concurrent transactions not noticing any previous locks held by transactions that might still be running, and thus being able to acquire subsequent locks they wouldn't be normally able to acquire. This bug was introduced in commit 1ce150b7bb; backpatch this fix to 9.3, like that commit. This change reverts the change to the delete-abort-savept isolation test in 1ce150b7bb, because that behavior change was caused by this bug. Noticed by Andres Freund while investigating a different issue reported by Noah Misch. http://git.postgresql.org/pg/commitdiff/07aeb1fec571920839822c11851d38ef48952d6c - Fix improper abort during update chain locking. In 247c76a98909, I added some code to do fine-grained checking of MultiXact status of locking/updating transactions when traversing an update chain. There was a thinko in that patch which would have the traversing abort, that is return HeapTupleUpdated, when the other transaction is a committed lock-only. In this case we should ignore it and return success instead. Of course, in the case where there is a committed update, HeapTupleUpdated is the correct return value. A user-visible symptom of this bug is that in REPEATABLE READ and SERIALIZABLE transaction isolation modes spurious serializability errors can occur: ERROR: could not serialize access due to concurrent update In order for this to happen, there needs to be a tuple that's key-share- locked and also updated, and the update must abort; a subsequent transaction trying to acquire a new lock on that tuple would abort with the above error. The reason is that the initial FOR KEY SHARE is seen as committed by the new locking transaction, which triggers this bug. (If the UPDATE commits, then the serialization error is correctly reported.) When running a query in READ COMMITTED mode, what happens is that the locking is aborted by the HeapTupleUpdated return value, then EvalPlanQual fetches the newest version of the tuple, which is then the only version that gets locked. (The second time the tuple is checked there is no misbehavior on the committed lock-only, because it's not checked by the code that traverses update chains; so no bug.) Only the newest version of the tuple is locked, not older ones, but this is harmless. The isolation test added by this commit illustrates the desired behavior, including the proper serialization errors that get thrown. Backpatch to 9.3. http://git.postgresql.org/pg/commitdiff/312bde3d404f770943c992992565c73f0336d21b Fujii Masao pushed: - Expose qurey ID in pg_stat_statements view. The query ID is the internal hash identifier of the statement, and was not available in pg_stat_statements view so far. Daniel Farina, Sameer Thakur and Peter Geoghegan, reviewed by me. http://git.postgresql.org/pg/commitdiff/91484409bdd17f330d10671d388b72d4ef1451d7 Magnus Hagander pushed: - Fix a couple of typos. Noted by Peter Geoghegan http://git.postgresql.org/pg/commitdiff/54aa5ef7f2dbe979843daf0c7a0d98f6709da4e6 - Fix pg_stat_statements build on 32-bit systems. Peter Geoghegan http://git.postgresql.org/pg/commitdiff/33d3f5594ac0cc4b6df3bf29b39db93bc32f1213 Joe Conway pushed: - Fix performance regression in dblink connection speed. Previous commit e5de601267d98c5d60df6de8d436685c7105d149 modified dblink to ensure client encoding matched the server. However the added PQsetClientEncoding() call added significant overhead. Restore original performance in the common case where client encoding already matches server encoding by doing nothing in that case. Applies to all active branches. Issue reported and work sponsored by Zonar Systems. http://git.postgresql.org/pg/commitdiff/d6ca510d9dbacceb3444f00fcfbba2c80dca4c8f == Rejected Patches (for now) == No one was disappointed this week :-) == Pending Patches == Brar Piening sent in a patch to enable Microsoft Visual Studio 2013 as additional build environment. Sergey Muraviov sent in a patch to help psql display wide tables more legibly. Zoltan Boszormenyi and Antonin Houska traded patches to allow backup throttling. Amit Kapila and Haribabu Kommi traded patches to reduce WAL for update operations. Heikki Linnakangas sent in a patch to optimize log_newpage by leaving out unused space from the block. Marko Kreen sent in a patch to allow using TLSv1.1+ in libpq. Stas Kelvich sent in another revision of a patch to add KNN support to the cube extension. SAKAMOTO Masahiko sent in another revision of a patch to allow forcing a WAL log when setting a hint bit. MauMau sent in two revisions of a patch to place DLLs in the bin folder for ECPG on Windows. Tom Lane sent in a patch intended to bridge the gap between ruleutils and empty targetlists. Etsuro Fujita sent in another revision of a patch to get more out of indexes via pathkeys and unique indexes. MauMau sent in two revisions of a patch to fix an issue where "pg_ctl stop" times out when it should respond quickly. Fabrízio de Royes Mello sent in two more revisions of a patch to enable creating time-delayed standbys. KaiGai Kohei and Shigeru HANADA traded patches implementing (and fixing typos in) a custom scan API. MauMau sent in a patch to fix a bug where psql's \conninfo reports an incorrect destination on Windows. Andres Freund sent in another flock of patches for logical changesets. Zoltan Boszormenyi sent in another revision of a patch to implement ECPG readahead. Zoltan Boszormenyi sent in two more revisions of a patch to fix the ECPG infrastructure. Peter Geoghegan sent in a patch to do some performance optimization of btree binary search. Michael Paquier sent in a patch to fix a bug where regression tests fail if not launched on a database itself called "regression." Kevin Grittner sent in a patch to fix a pg_archivecleanup issue. Antonin Houska sent in a patch to reference to a parent query from ANY sublink. MauMau sent in a patch to fix an issue where pg_ctl fails with config-only directory on Windows. Dr. Andreas Kunert sent in three revisions of a patch to allow logging SSL connections. MauMau sent in two revisions of a patch to fix an issue on Windows where pg_ctl always used the same event source. MauMau sent in a patch to allow a client-only installation on Windows. Andres Freund sent in a patch to add %z ((s)size_t) support to elog/ereport. Pavel Stehule and Dean Rasheed traded more revisions of the patch to add DROP ... IF EXISTS ... in the current places where that construct makes sense.