== PostgreSQL Weekly News - December 30 2012 ==
От | David Fetter |
---|---|
Тема | == PostgreSQL Weekly News - December 30 2012 == |
Дата | |
Msg-id | 20121231072532.GA28423@fetter.org обсуждение исходный текст |
Список | pgsql-announce |
== PostgreSQL Weekly News - December 30 2012 == == PostgreSQL Product News == dbForge Data Compare for PostgreSQL, a data diff and sync tool for PostgreSQL that allows users to review all the differences in compared tables and execute an automatically generated script to remove these differences, released. http://www.devart.com/dbforge/postgresql/datacompare/ pgFormatter v1.1, a SQL formatter/beautifier which supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL keywords are not in the standard, released. http://sqlformat.darold.net/ PG Jobmon version 1.0.0, an extension for autonomously logging steps of a function, released. https://github.com/omniti-labs/pg_jobmon == PostgreSQL Jobs for December == http://archives.postgresql.org/pgsql-jobs/2012-12/threads.php == PostgreSQL Local == The FOSDEM PGDay conference that will be held before FOSDEM in Brussels, Belgium, on Feb 1st, 2013. The CfP for both this event and for the PG track of FOSDEM are open. http://fosdem2013.pgconf.eu/callforpapers/ PyPgDay will be held on March 13th at the Santa Clara Convention Center, the first day of PyCon. Info here: http://wiki.postgresql.org/wiki/PyPgDay2013 Submit your proposal here by January 20, 2013: http://tinyurl.com/PyPgDayCfP PGDay NYC 2013 will be held on March 22, 2013 in New York City. The CfP submission deadline is January 7th, 2013 at noon eastern time. papers AT nycpug DOT org. http://pgday.nycpug.org/speakers PostgreSQL Session will be held on March 28th, 2013 in Paris, France. The Call for Papers is open. http://www.postgresql-sessions.org/en/5/ PGCon 2013 will be held May 23-24 2013, in Ottawa at the University of Ottawa. The Call for Papers is open. http://www.pgcon.org/2013/ == 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 == Simon Riggs pushed: - Add function prototype from previous commit. http://git.postgresql.org/pg/commitdiff/2dcb2ebee2ec830fbe547459b2176238efc2a3e0 - Fix more weird compiler messages caused by unmatched function prototypes. Andres Freund http://git.postgresql.org/pg/commitdiff/42fa810c144cb76c911cc664244bc369911eb840 - Keep rd_newRelfilenodeSubid across overflow. Teach RelationCacheInvalidate() to keep rd_newRelfilenodeSubid across rel cache message overflows, so that behaviour is now fully deterministic. Noah Misch http://git.postgresql.org/pg/commitdiff/ae9aba69a8608c6e5df01ee4f20c4799f5d2850c - Update comments on rd_newRelfilenodeSubid. Ensure comments accurately reflect state of code given new understanding, and recent changes. Include example code from Noah Misch to illustrate how rd_newRelfilenodeSubid can be reset deterministically. No code changes. http://git.postgresql.org/pg/commitdiff/c2b32180649fe9105e784ad0519fe243605f78a3 Tom Lane pushed: - Fix some minor issues in view pretty-printing. Code review for commit 2f582f76b1945929ff07116cd4639747ce9bb8a1: don't use a static variable for what ought to be a deparse_context field, fix non-multibyte-safe test for spaces, avoid useless and potentially O(N^2) (though admittedly with a very small constant) calculations of wrap positions when we aren't going to wrap. http://git.postgresql.org/pg/commitdiff/3f88b080030682adf359248c9cb7f8b2068a539e Bruce Momjian pushed: - Add pg_upgrade --jobs parameter. Add pg_upgrade --jobs, which allows parallel dump/restore of databases, which improves performance. http://git.postgresql.org/pg/commitdiff/6f1b9e4efd94fc644f5de5377829d42e48c3c758 Peter Eisentraut pushed: - doc: Replace "NOTE" with proper markup http://git.postgresql.org/pg/commitdiff/925ce77c0359eff9310f7954294f257dafb0c2db - doc: Correct description of LDAP authentication. Parts of the description had claimed incorrect pg_hba.conf option names for LDAP authentication. Laurenz Albe. http://git.postgresql.org/pg/commitdiff/103cc89362accb04cf37a9063e51eac04d489e89 - Fix compiler warning about uninitialized variable http://git.postgresql.org/pg/commitdiff/0e690209eec61f8b70c57f8feeab0a3cd853103b - doc: Correct description of ldapurl. The ldapurl option doesn't actually support specifying a user name and password. Laurenz Albe. http://git.postgresql.org/pg/commitdiff/7eb559a86d773e0105ae5823e0c776c3af3c3fe2 Alvaro Herrera pushed: - Remove unused NextLogPage macro. Commit 061e7efb1b did away with its last caller, but neglected to remove the actual definition. Author: Andres Freund http://git.postgresql.org/pg/commitdiff/eaa1f7220ae83997b56adcae1fbb7b2e92bfc050 - Assign InvalidXLogRecPtr instead of MemSet(0) For consistency. Author: Andres Freund http://git.postgresql.org/pg/commitdiff/24eca7977ed208de33791af8890975ffcf086598 - Remove obsolete XLogRecPtr macros. This gets rid of XLByteLT, XLByteLE, XLByteEQ and XLByteAdvance. These were useful for brevity when XLogRecPtrs were split in xlogid/xrecoff; but now that they are simple uint64's, they are just clutter. The only downside to making this change would be ease of backporting patches, but that has been negated by other substantive changes to the involved code anyway. The clarity of simpler expressions makes the change worthwhile. Most of the changes are mechanical, but in a couple of places, the patch author chose to invert the operator sense, making the code flow more logical (and more in line with preceding comments). Author: Andres Freund Eyeballed by Dimitri Fontaine and Alvaro Herrera http://git.postgresql.org/pg/commitdiff/5ab3af46ddd2f2c2b248f1ffdb688b394d4bb387 Robert Haas pushed: - Adjust more backend functions to return OID rather than void. This is again intended to support extensions to the event trigger functionality. This may go a bit further than we need for that purpose, but there's some value in being consistent, and the OID may be useful for other purposes also. Dimitri Fontaine http://git.postgresql.org/pg/commitdiff/82b1b213cad3a69cf5f3dfaa81687c14366960fc Heikki Linnakangas pushed: - Keep timeline history files restored from archive in pg_xlog. The cascading standby patch in 9.2 changed the way WAL files are treated when restored from the archive. Before, they were restored under a temporary filename, and not kept in pg_xlog, but after the patch, they were copied under pg_xlog. This is necessary for a cascading standby to find them, but it also means that if the archive goes offline and a standby is restarted, it can recover back to where it was using the files in pg_xlog. It also means that if you take an offline backup from a standby server, it includes all the required WAL files in pg_xlog. However, the same change was not made to timeline history files, so if the WAL segment containing the checkpoint record contains a timeline switch, you will still get an error if you try to restart recovery without the archive, or recover from an offline backup taken from the standby. With this patch, timeline history files restored from archive are copied into pg_xlog like WAL files are, so that pg_xlog contains all the files required to recover. This is a corner-case pre-existing issue in 9.2, but even more important in master where it's possible for a standby to follow a timeline switch through streaming replication. To make that possible, the timeline history files must be present in pg_xlog. http://git.postgresql.org/pg/commitdiff/60df192aea0e6458f20301546e11f7673c102101 == Rejected Patches (for now) == No one was disappointed this week :-) == Pending Patches == Dimitri Fontaine sent in four more revisions of a patch to add EVENT triggers. Pavel Stehule sent in a patch to add a regrole type. Andrew Dunstan sent in another WIP patch for the JSON API. Peter Bex sent in a patch intended to improve password hashing by adding bcrypt. Alvaro Herrera and Heikki Linnakangas traded patches to fix bgworkers in the EXEC_BACKEND case. Kyotaro HORIGUCHI sent in two more revisions of a patch to reduce the amount of WAL generated during update operations. Alvaro Herrera sent in another revision of a patch to implement foreign key locks. Heikki Linnakangas sent in a patch to fix a performance regression in dynamic SQL by eliminating some unneeded copying of the parse- and plan trees. Pavel Stehule sent in a patch to implement SQL:2011 named parameters. Dan Farina sent in four revisions of a patch to establish a maximum under-estimate of the number of calls for a given pg_stat_statements entry. That means the number of calls to the canonical form of the query is between 'calls' and 'calls + calls_underest'. Pavel Stehule sent in another revision of a patch to enhance error fields in PL/pgsql. Tom Lane sent in a patch to make view dump/restore safe at the column-alias level. Craig Ringer sent in a patch to change the Windows build docs to point to flex and bison from msys.
В списке pgsql-announce по дате отправления: