== PostgreSQL Weekly News - June 23 2013 ==
От | David Fetter |
---|---|
Тема | == PostgreSQL Weekly News - June 23 2013 == |
Дата | |
Msg-id | 20130624022914.GR5395@fetter.org обсуждение исходный текст |
Список | pgsql-announce |
== PostgreSQL Weekly News - June 23 2013 == PGDay Italy will be in Prato, Tuscany on October 25, 2013. Watch this space for more details. == PostgreSQL Product News == pgBadger 3.4, a parallel PostgreSQL log analyzer written in Perl, released: https://sourceforge.net/projects/pgbadger/ PG Commander, a PostgreSQL client for OS X, released. http://eggerapps.at/pgcommander/ PostGIS 2.1.0beta3, the industry standard geographic information system for PostgreSQL, released. http://postgis.net/2013/06/22/postgis-2-1-0beta3 psycopg2 2.5.1, a Python connector for PostgreSQL, released. http://initd.org/psycopg/articles/2013/06/23/psycopg-251-released/ == PostgreSQL Jobs for June == http://archives.postgresql.org/pgsql-jobs/2013-06/threads.php == PostgreSQL Local == We're going to have a booth at OSCON this year. Please sign up and hang out at the booth for an hour or two: https://wiki.postgresql.org/wiki/Oscon_2013_signup PGDay UK 2013 is July 12, 2013. Registration is open. http://postgresqlusergroup.org.uk PostgreSQL Brazil will be held August 15-17, 2013 in Porto Velho, RO, Brazil. http://pgbr.postgresql.org.br/2013/chamada.en.php Postgres Open 2013 will be in Chicago, IL, USA, September 16-18. Early Bird registration and call for presentations closes June 30th. http://postgresopen.org/ pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel in downtown Dublin, Ireland. The CfP 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/ == 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 == Jeff Davis pushed: - Add buffer_std flag to MarkBufferDirtyHint(). MarkBufferDirtyHint() writes WAL, and should know if it's got a standard buffer or not. Currently, the only callers where buffer_std is false are related to the FSM. In passing, rename XLOG_HINT to XLOG_FPI, which is more descriptive. Back-patch to 9.3. http://git.postgresql.org/pg/commitdiff/b8fd1a09f382f04c41128fded4d56da2127ce92d Peter Eisentraut pushed: - psql: Re-allow -1 together with -c or -l http://git.postgresql.org/pg/commitdiff/c3c86ae2aff67676a49ec84240f1d6a482f359cb - initdb: Add blank line before output about checksums. This maintains the logical grouping of the output better. http://git.postgresql.org/pg/commitdiff/8df54b9fad9b7954b71c63b86a6c587fc6748099 - Further update CREATE FUNCTION documentation about argument names. More languages than SQL and PL/pgSQL actually support parameter names. http://git.postgresql.org/pg/commitdiff/4c54e87a86d6e73aa3a3b7710fa3db33297792d4 - Clarify terminology standalone backend vs. single-user mode. Most of the documentation uses "single-user mode", so use that in the code as well. Adjust the documentation to match the new error message wording. Also add a documentation index entry for "single-user mode". Based-on-patch-by: Jeff Janes. http://git.postgresql.org/pg/commitdiff/7dfd5cd21c0091e467b16b31a10e20bbedd0a836 - doc: Fix date in EPUB manifest. If there is no <date> element, the publication date for the EPUB manifest is taken from the copyright year. But something like "1996-2013" is not a legal date specification. So the EPUB output currently fails epubcheck. Put in a separate <date> element with the current year. Put it in legal.sgml, because copyright.pl already instructs to update that manually, so it hopefully won't be missed. http://git.postgresql.org/pg/commitdiff/dab1603e5238d3abce9f7a3a7b9450888cc07c70 Simon Riggs pushed: - Fix docs on lock level for ALTER TABLE VALIDATE. ALTER TABLE .. VALIDATE CONSTRAINT previously gave incorrect details about lock levels and therefore incomplete reasons to use the option. Initial bug report and fix from Marko Tiikkaja Reworded by me to include comments by Kevin Grittner http://git.postgresql.org/pg/commitdiff/073d7cb513f5de44530f4bdbaaa4b5d4cce5f984 - Ensure no xid gaps during Hot Standby startup. In some cases with higher numbers of subtransactions it was possible for us to incorrectly initialize subtrans leading to complaints of missing pages. Bug report by Sergey Konoplev. Analysis and fix by Andres Freund. http://git.postgresql.org/pg/commitdiff/1f09121b4edee8b4d4cdd4ee0a8cffacee7b85f7 Kevin Grittner pushed: - Fix the create_index regression test for Danish collation. In Danish collations, there are letter combinations which sort higher than 'Z'. A test for values > 'WA' was picking up rows where the value started with 'Ants Aasma', causing the test to fail. Backpatch to 9.2, where the failing test was added. Per report from Svenne Krap and analysis by Jeff Janes http://git.postgresql.org/pg/commitdiff/8791627b8f9a9ce44603beec447bc6f18bfd9a36 Bruce Momjian pushed: - Modernize entab source code. Remove halt.c, improve comments, rename manual page file. http://git.postgresql.org/pg/commitdiff/f979599b2068f036405f1b51a9c4260619b06941 Fujii Masao pushed: - Support TB (terabyte) memory unit in GUC variables. Patch by Simon Riggs, reviewed by Jeff Janes and me. http://git.postgresql.org/pg/commitdiff/bab54e383dd102001753366d3c124f706c7967dd Tom Lane pushed: - Add a comment warning against use of pg_usleep() for long sleeps. Follow-up to commit 873ab97219caabeb2f7b390268a4fe01e2b7518c, in which I noted that WaitLatch was a better solution in the commit log message, but neglected to add any documentation in the code. http://git.postgresql.org/pg/commitdiff/8c1a71d36f5d667f3c2236e0e015a48f809ca240 == Rejected Patches (for now) == No one was disappointed this week :-) == Pending Patches == David Fetter sent in another revision of a patch to implement makeFuncArgs. Andres Freund sent in a patch to clarify an error message on Linux. Robins Tharakan sent in another revision of a patch to add regression tests for SET xxx. Alexander Korotkov sent in two more revisions of a patch to add more information to GIN indexes. Alexander Korotkov sent in two more revisions of a patch to add ordering in GIN indexes. Alexander Korotkov sent in two more revisions of a patch to add fast scan to GIN indexes. Ian Link sent in a patch to improve the fast GIN cache. Michael Paquier sent in five more revisions of a patch to implement REINDEX CONCURRENTLY. Jeff Davis sent in another revision of a patch to have pg_filedump take checksums, among other things, into account. Amit Langote sent in a patch to correct a comment in heaptuple.c. Cedric Villemain sent in a patch to fix a bug and add new features to pgxs. Etsuro Fujita sent in four more revisions of a patch to remove unused targets. Nicholas White and Troels Nielsen traded patches to allow the SQL standard IGNORE/RESPECT NULLS in lead and lag window functions. Heikki Linnakangas sent in two more revisions of a patch to scale XLogInserts. Amit Kapila sent in another revision of a patch to allow changing GUCs persistently from SQL. Fabien COELHO sent in another revision of a patch to add long options to pgbench. Andres Freund sent in a patch to create a new contrib module: xidfuncs. Jeff Janes sent in another revision of a patch to add a startup option to pgbench. Josh Kupershmidt sent in a patch to rename the specs directory to something that won't interfer with certain OSs. Andres Freund sent in another revision of a patch to create infrastructure for and implement examples of pluggable compressors. Gurjeet Singh sent in a patch to implement a function pg_test_reload_conf() which allows you to know whether the changes you've made to configuration parameters have actually taken effect after a SIGHUP. KONDO Mitsumasa sent in another revision of a patch to add --progress to pgbench. Andres Freund sent in two more revisions of the set of patches to implement WAL decoding. David Fetter sent in another revision of a patch to implement FILTER, this time without the restriction that certain types of subqueries couldn't be in the FILTER clause. Dean Rasheed sent in a patch on top of same to make FILTER an unreserved word. Alexander Korotkov sent in a patch to fix an irregularity in trigram indexes. Andres Freund sent in a WIP patch to fix a corner case in CASE. Andrew Dunstan sent in a patch to fix pg_dump for foreign tables in the pg_upgrade scenario. Fabien COELHO sent in another revision of a patch to implement CREATE CAST...AS EXPLICIT. Simon Riggs and Heikki Linnakangas traded patches to fix how hashes work in some edge cases. Fabien COELHO sent in another revision of a patch to implement pgbench --throttle. Noah Misch sent in another revision of a patch to make Windows behave better with different encodings.
В списке pgsql-announce по дате отправления: