== PostgreSQL Weekly News - September 21 2014 == - Mailing list pgsql-announce
From | David Fetter |
---|---|
Subject | == PostgreSQL Weekly News - September 21 2014 == |
Date | |
Msg-id | 20140922065710.GA30625@fetter.org Whole thread Raw |
List | pgsql-announce |
== PostgreSQL Weekly News - September 21 2014 == The first Moscow PostgreSQL event organized through Meetup will be in Moscow, Russia, September 24, 2014. RSVP in advance to help the organizers. http://www.meetup.com/postgresqlrussia/ == PostgreSQL Jobs for September == http://archives.postgresql.org/pgsql-jobs/2014-09/threads.php == PostgreSQL Local == The fifth edition of the Argentinian PostgreSQL Day will be held on November 28th, 2014 in Santa Fe, Argentina. The International CfP is open through September 28th, 2014. http://www.postgresql.org.ar/pgday2014 The 4th PgDay Ecuador will be held on Tuesday 7th in October at the city of Quito, as part of the 5th International Congress of Free Software. Send talk proposals to ecpug AT postgresql DOT org. The sixth PGDay Cubano be held on 13 and 14 October 2014 in Habana. https://postgresql.uci.cu/?p=380 PGConf.EU 2014 in Madrid, Spain on October 21-24 is now open for registration. http://2014.pgconf.eu/registration/ PGDay.IT 2014 will take place in Prato on November the 7th 2014. The International Call For Papers is now open: http://2014.pgday.it/call-for-papers-en/ == 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 == Heikki Linnakangas pushed: - Follow the RFCs more closely in libpq server certificate hostname check. The RFCs say that the CN must not be checked if a subjectAltName extension of type dNSName is present. IOW, if subjectAltName extension is present, but there are no dNSNames, we can still check the CN. Alexey Klyukin http://git.postgresql.org/pg/commitdiff/58e70cf9fb42c1ad60b8ba730fd129f2ce6fa332 - Fix the return type of GIN triConsistent support functions to "char". They were marked to return a boolean, but they actually return a GinTernaryValue, which is more like a "char". It makes no practical difference, as the triConsistent functions cannot be called directly from SQL because they have "internal" arguments, but this nevertheless seems more correct. Also fix the GinTernaryValue name in the documentation. I renamed the enum earlier, but neglected the docs. Alexander Korotkov. This is new in 9.4, so backpatch there. http://git.postgresql.org/pg/commitdiff/77e65bf369edd0282531794dd907a0943651eff8 Peter Eisentraut pushed: - Fix TAP checks when current directory name contains spaces. Add some quotes in the makefile snippet that creates the temporary installation, so that it can handle spaces in the directory name and possibly some other oddities. http://git.postgresql.org/pg/commitdiff/f7d6759ec2df9ad10b65aea359a27789e16a353b Andres Freund pushed: - Fix configure check for %z printf support after INT64_MODIFIER changes. The PGAC_FUNC_SNPRINTF_SIZE_T_SUPPORT test was broken by ce486056ecd28050. Among others it made the UINT64_FORMAT macro to be defined in c.h, instead of directly being defined by configure. This lead to the replacement printf being used on all platforms for a while. Which seems to work, because this was only used due to different profiles ;) Fix by relying on INT64_MODIFIER instead. http://git.postgresql.org/pg/commitdiff/7e3f728353fa9b36c7f98b6ec447d3f1b8deec14 - Add the capability to display summary statistics to pg_xlogdump. The new --stats/--stats=record options to pg_xlogdump display per rmgr/per record statistics about the parsed WAL. This is useful to understand what the WAL primarily consists of, to allow targeted optimizations on application, configuration, and core code level. It is likely that we will want to fine tune the statistics further, but the feature already is quite helpful. Author: Abhijit Menon-Sen, slightly editorialized by me Reviewed-By: Andres Freund, Dilip Kumar and Furuya Osamu Discussion: 20140604104716.GA3989@toroid.org http://git.postgresql.org/pg/commitdiff/bdd5726c347016ea34e9fb68d1b8b71046e25d2e - Add rmgr callback to name xlog record types for display purposes. This is primarily useful for the upcoming pg_xlogdump --stats feature, but also allows to remove some duplicated code in the rmgr_desc routines. Due to the separation and harmonization, the output of dipsplayed records changes somewhat. But since this isn't enduser oriented content that's ok. It's potentially desirable to further change pg_xlogdump's display of records. It previously wasn't possible to show the record type separately from the description forcing it to be in the last column. But that's better done in a separate commit. Author: Abhijit Menon-Sen, slightly editorialized by me Reviewed-By: Álvaro Herrera, Andres Freund, and Heikki Linnakangas Discussion: 20140604104716.GA3989@toroid.org http://git.postgresql.org/pg/commitdiff/728f152e07f998d2cb4fe5f24ec8da2c3bda98f2 - Avoid 'clobbered by longjmp' warning in psql/copy.c. This was introduced in 51bb79569f934ad2135c2ff859c61b9ab8d51750. http://git.postgresql.org/pg/commitdiff/afaefa1b31ba900bdc6987a752483e1580356e48 - Mark x86's memory barrier inline assembly as clobbering the cpu flags. x86's memory barrier assembly was marked as clobbering "memory" but not "cc" even though 'addl' sets various flags. As it turns out gcc on x86 implicitly assumes "cc" on every inline assembler statement, so it's not a bug. But as that's poorly documented and might get copied to architectures or compilers where that's not the case, it seems better to be precise. Discussion: 20140919100016.GH4277@alap3.anarazel.de To keep the code common, backpatch to 9.2 where explicit memory barriers were introduced. http://git.postgresql.org/pg/commitdiff/e5603a2f35baa0bc9d61b16373383fdd37e49509 Robert Haas pushed: - Add a fast pre-check for equality of equal-length strings. Testing reveals that that doing a memcmp() before the strcoll() costs practically nothing, at least on the systems we tested, and it speeds up sorts containing many equal strings significatly. Peter Geoghegan. Review by myself and Heikki Linnakangas. Comments rewritten by me. http://git.postgresql.org/pg/commitdiff/e246b3d6eac09d0770e6f68e69f2368d02db88af - doc: Use <literal> and all-caps for READ COMMITTED isolation level. The documentation overall is not entirely consistent about how we do this, but this is consistent with other usages within lock.sgml. Etsuro Fujita http://git.postgresql.org/pg/commitdiff/a92b5f969bed9796bcb3c321e7be4124a4533067 Tom Lane pushed: - Fix failure of contrib/auto_explain to print per-node timing information. This has been broken since commit af7914c6627bcf0b0ca614e9ce95d3f8056602bf, which added the EXPLAIN (TIMING) option. Although that commit included updates to auto_explain, they evidently weren't tested very carefully, because the code failed to print node timings even when it should, due to failure to set es.timing in the ExplainState struct. Reported off-list by Neelakanth Nadgir of Salesforce. In passing, clean up the documentation for auto_explain's options a little bit, including re-ordering them into what seems to me a more logical order. http://git.postgresql.org/pg/commitdiff/898f8a96ef9dfa79eac9ec1621a89e71fe16601c Stephen Frost pushed: - Row-Level Security Policies (RLS) Building on the updatable security-barrier views work, add the ability to define policies on tables to limit the set of rows which are returned from a query and which are allowed to be added to a table. Expressions defined by the policy for filtering are added to the security barrier quals of the query, while expressions defined to check records being added to a table are added to the with-check options of the query. New top-level commands are CREATE/ALTER/DROP POLICY and are controlled by the table owner. Row Security is able to be enabled and disabled by the owner on a per-table basis using ALTER TABLE .. ENABLE/DISABLE ROW SECURITY. Per discussion, ROW SECURITY is disabled on tables by default and must be enabled for policies on the table to be used. If no policies exist on a table with ROW SECURITY enabled, a default-deny policy is used and no records will be visible. By default, row security is applied at all times except for the table owner and the superuser. A new GUC, row_security, is added which can be set to ON, OFF, or FORCE. When set to FORCE, row security will be applied even for the table owner and superusers. When set to OFF, row security will be disabled when allowed and an error will be thrown if the user does not have rights to bypass row security. Per discussion, pg_dump sets row_security = OFF by default to ensure that exports and backups will have all data in the table or will error if there are insufficient privileges to bypass row security. A new option has been added to pg_dump, --enable-row-security, to ask pg_dump to export with row security enabled. A new role capability, BYPASSRLS, which can only be set by the superuser, is added to allow other users to be able to bypass row security using row_security = OFF. Many thanks to the various individuals who have helped with the design, particularly Robert Haas for his feedback. Authors include Craig Ringer, KaiGai Kohei, Adam Brightwell, Dean Rasheed, with additional changes and rework by me. Reviewers have included all of the above, Greg Smith, Jeff McCormick, and Robert Haas. http://git.postgresql.org/pg/commitdiff/491c029dbc4206779cf659aa0ff986af7831d2ff == Rejected Patches (for now) == No one was disappointed this week :-) == Pending Patches == Marko (johto) Tiikkaja sent in another revision of a patch to add PGP signatures to the pgcrypto contrib extension. Kevin Grittner sent in another revision of a patch to add the capacity to use intermediate tables in queries with an immediate eye to the maintenance of materialized views. Heikki Linnakangas sent in another revision of a patch to add a pgbench throttling latency limit. Heikki Linnakangas sent in another revision of a patch to change the WAL format and API. David Rowley sent in two more revisions of a patch to remove inner joins in certain cases where they can be proven redundant. Joachim Wieland sent in another revision of a patch to remove global variables from pg_dump. Szymon Guz sent in two revisions of a patch to add asciidoc as a format psql can use for output. Heikki Linnakangas sent in another revision of a patch to fix an issue where JSONB compressed poorly. Kaigai Kouhei sent in another revision of a patch to implement a custom plan API. Andres Freund sent in a patch to remove the volatile qualifiers from xlog.c. Kyotaro HORIGUCHI sent in another revision of a patch to process pg_hba.conf keywords as case-insensitive. Pavel Stehule sent in two more revisions of a patch to document unicode border styles in psql. Michael Paquier sent in a patch to remove OUTPUT_PLUGIN_* from existing logical decoding APIs. Robert Haas sent in a patch to fix an issue where identify_locking_dependencies was broken for schema-only dumps. Petr (PJMODOS) Jelinek sent in a patch to fix a couple of instances where COPY_SCALAR_FIELD is called instead of the correct COPY_STRING_FIELD. Amit Kapila sent in two more revisions of a patch to scale shared buffer eviction. Dean Rasheed sent in two revisions of a patch to ensure that WITH CHECK OPTION works correctly with row-level access control. Haribabu Kommi sent in another revision of a patch to fix some oddities in per-table autovacuum vacuum cost limit behaviour. Michael Paquier sent in two more revisions of a patch to refactor pg_basebackup and support for replslot creation and drop in pg_receivexlog. Michael Paquier sent in another revision of a patch to make pg_dump able to dump from replication slot creation state. Rajeev Rastogi sent in a patch to optimize index scans. Michael Paquier sent in a patch to fix the documentation for pg_recvlogical's --create mode.
pgsql-announce by date: