== PostgreSQL Weekly News - September 15 2013 ==
От | David Fetter |
---|---|
Тема | == PostgreSQL Weekly News - September 15 2013 == |
Дата | |
Msg-id | 20130916063757.GB9493@fetter.org обсуждение исходный текст |
Список | pgsql-announce |
== PostgreSQL Weekly News - September 15 2013 == The second PostgreSQL CommitFest of the new development cycle has begun. https://commitfest.postgresql.org/action/commitfest_view/inprogress http://wiki.postgresql.org/wiki/Reviewing_a_Patch https://commitfest.postgresql.org/action/commitfest_view?id=19 == PostgreSQL Product News == PG Partition Manager 1.4.0, an extension to manage time- or serial-based table partitioning, released. https://github.com/keithf4/pg_partman Slony-I 2.2.0, a trigger-based replication system for PostgreSQL, released. http://www.slony.info/ == PostgreSQL Jobs for September == http://archives.postgresql.org/pgsql-jobs/2013-09/threads.php == PostgreSQL Local == Open Source Software for Business" (OSS4B) 2013 will be held in Prato, Tuscany, Italy on September 19 and 20. Registration is open. http://www.oss4b.it/ The PostgreSQL Conference China for 2013 will be held October 26-27, 2013 in Hangzhou. Chinese language information here: https://wiki.postgresql.org/wiki/Pgconf_cn2013 Registration: http://bbs.pgsqldb.com/client/bm.php The Italian PGDay (PGDay.IT) will be held on October the 25th in Prato, Tuscany, Italy, at Monash University Center. To register to the event or get information about the accepted talks and schedule please see the official web site: http://2013.pgday.it pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel in downtown Dublin, Ireland. Registration is open. http://2013.pgconf.eu/ PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland Industrial Museum in Oberhausen. The CfP is open through September 15, 2013. http://2013.pgconf.de/ The fourth edition of the Argentinian PostgreSQL Day will be held on November 14 2013 in Buenos Aires, Argentina. The CfP is open. http://wiki.postgresql.org/wiki/PGDay_Argentina_2013 PGDay Cuba will be in November, 2013. http://postgresql.uci.cu/ == 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@fetter.org, German language to pwn@pgug.de, Italian language to pwn@itpug.org. Spanish language to pwn@arpug.com.ar. == Applied Patches == Robert Haas pushed: - Introduce InvalidCommandId. This allows a 32-bit field to represent an *optional* command ID without a separate flag bit. Andres Freund http://git.postgresql.org/pg/commitdiff/71901ab6daaad65c0168c05e016e4208efe5b71a Peter Eisentraut pushed: - Show schemas in information_schema.schemata that the current has access to. Before, it would only show schemas that the current user owns. Per discussion, the new behavior is more useful and consistent for PostgreSQL. http://git.postgresql.org/pg/commitdiff/b34f8f409bec4921d260ac84668917f5fff04319 - Fix typos http://git.postgresql.org/pg/commitdiff/cdeb79adcfb2e46efd4f76c39184dd452ae1acd0 Fujii Masao pushed: - Remove leftover function prototype. The prototype for inval_twophase_postcommit wasn't removed when it's definition was removed in efc16ea520679d713d98a2c7bf1453c4ff7b91ec / the initial Hot Standby commit. Andres Freund http://git.postgresql.org/pg/commitdiff/71129b6fc5a7f1a7615f9ee07ee55994217de994 Bruce Momjian pushed: - psql: honor 'footer' option for expanded output. "No rows" previously only honored the tuples-only option. Per report from Eli Mesika http://git.postgresql.org/pg/commitdiff/601f48076f8036a223f631692db83ec661f785a6 - psql: fix \copy stdin trailing space requirement. Previously a trailing space was required for \copy ... stdin: copy foo from stdin ; Etsuro Fujita http://git.postgresql.org/pg/commitdiff/d8a5608d4ac9d4b74772980666cc6626bd18c3ff - Add comment for VARSIZE_ANY_EXHDR macro. Gurjeet Singh http://git.postgresql.org/pg/commitdiff/0f59f4a645ec92e580baa4c8feb9f285a8279a15 - docs: Update libpq and testlo examples. Josh Kupershmidt http://git.postgresql.org/pg/commitdiff/2885006afc81aaabf3a32a873bbed99282f5a978 - fuzzystrmatch: replace broken link in C comment. Laurenz Albe. http://git.postgresql.org/pg/commitdiff/f0e86930dd56f2da00101d5384cbb51ada3730da Kevin Grittner pushed: - Create index on srt table in citext regression tests. Comments and the tests make clear that the intent is to test with and without an index, but there was no index. http://git.postgresql.org/pg/commitdiff/a49d0b75ce41a5480777f0957d5119cb2f393414 Noah Misch pushed: - Ignore interrupts during quickdie(). Once the administrator has called for an immediate shutdown or a backend crash has triggered a reinitialization, no mere SIGINT or SIGTERM should change that course. Such derailment remains possible when the signal arrives before quickdie() blocks signals. That being a narrow race affecting most PostgreSQL signal handlers in some way, leave it for another patch. Back-patch this to all supported versions. http://git.postgresql.org/pg/commitdiff/d41cb869aad493178777b6e6e8d1425535349acb == Rejected Patches (for now) == No one was disappointed this week :-) == Pending Patches == Peter Geoghegan sent in two revisions of a patch to implement INSERT ... ON DUPLICATE KEY LOCK FOR UPDATE. Zoltan Boszormenyi sent in another revision of a patch to implement fetch readahead for ECPG. Blake Smith sent in another revision of a patch to speed up queries with hstore using GIN indexes. Heikki Linnakangas and Stephen Frost traded patches to fix an issue in libpq's interaction with SSL. Satoshi Nagayasu sent in two more revisions of a patch to collect a statistic for WAL buffer dirty writes called pg_stat_walwriter.dirty_write. Noah Misch sent in a patch to fix a case where SIGQUIT sent after a query cancel, the cancel takes precedent and the backend survives. Bruce Momjian sent in a patch to issue a warning when SET TRANSACTION is called outside a transaction block. Ronan Dunklau sent in a patch to implement triggers on foreign tables. Bruce Momjian sent in a patch to fix some functions in contrib/unaccent to be immutable. Fujii Masao sent in another revision of a patch to compress full-page writes. Peter Eisentraut sent in a patch to document how to use FOP to build the PDF documentation. Samrat Revagade and Sawada Masahiko traded patches to allow fail-back without taking a fresh backup. Robert Haas sent in a set of patches to allow terminating background workers, a way to flag same, and some test code. This may eventually lead to parallel query. Peter Eisentraut sent in a patch to remove the maintainer-check target, roll its functionality into the regular build, and include Andrew Dunstan's check for duplicate OIDs. Peter Eisentraut sent in a patch to split off pg_fatal() from pg_log() in pg_upgrade. Kevin Grittner sent in a patch to implement a record_identical() operator as part of the infrastructure for maintaining materialized views. MauMau sent in another revision of a patch to make sure shutting down in immediate mode is reliable. Andrew (RhodiumToad) Gierth sent in another revision of a patch to make UNNEST take multiple heterogeneous array arguments and have TABLE() do similar with multiple SRFs. Robert Haas and Amit Kapila sent in another revision of a patch to implment dynamic shared memory. Dimitri Fontaine sent in a patch to complete the stock PL support for EVENT TRIGGERS. Peter Eisentraut sent in another revision of a patch to implement TRANSFORMS. Peter Eisentraut sent in a patch to use asprintf() on platforms that support it. Atri Sharma and Andrew (RhodiumToad) Gierth traded patches implementing WITHIN GROUP. Marko (johto) Tiikkaja sent in a patch to implement a strict mode for PL/pgsql. Richard Poole sent in a WIP patch to adds the MAP_HUGETLB flag to mmap() for shared memory on systems that support it. The patch is based on Christian Kruse's patch from last year, incorporating suggestions from Andres Freund. Marko (johto) Tiikkaja sent in three more revisions of a patch to add a COMPACT mode for errors where the CONTEXT field is omitted for all non-error messages. Marko (johto) Tiikkaja sent in two revisions of a patch to (optionally) print more information on STRICT failures in PL/PgSQL: Amit Kapila sent in another revision of a patch to compute the max LSN of pages. Peter Eisentraut sent in another revision of a patch to implement information_schema.parameters.parameter_default. Andres Freund sent in a patch to allow custom GUCs to be nested more that one level in config files. Peter Eisentraut sent in another revision of a patch to revive the line type. Bernd Helmle sent in a patch to create a GUC for page checksums. Alvaro Herrera sent in another revision of a patch to implement min-max indexes. Andres Freund sent in a flock of patches intended to help with logical changesets. Details here: http://www.postgresql.org/message-id/20130914204913.GA4071@awork2.anarazel.de Marko (johto) Tiikkaja sent in two revisions of a patch to add ASSERTions to PL/pgsql. Abhijit Menon-Sen sent in another revision of a patch to implement bitmap indexes. Amit Kapila sent in two more revisions of a patch to fix some inconsistent behavior in table inheritance. Satoshi Nagayasu sent in another revision of a patch to update contrib/pgstattuple. Alexander Korotkov sent in another revision of a patch to improve GIN indexes with optional information. Satoshi Nagayasu sent in another revision of a patch to add CLUSTER statistics.
В списке pgsql-announce по дате отправления: