---------- Forwarded message ----------
From: David Fetter <david at fetter.org>
Date: Mon, Nov 24, 2008 at 8:02 AM
Subject: [ANNOUNCE] == PostgreSQL Weekly News - November 23 2008 ==
To: PostgreSQL Announce <pgsql-announce at postgresql.org>


== PostgreSQL Weekly News - November 23 2008 ==

The first annual PGDay Argentina drew attendees from all over Latin
America, with lively talks.

Devrim GUNDUZ has published a new set of RPMs based on the Nov 18 2008
11:00 PM EEST CVS snapshot.
http://yum.pgsqlrpms.org/news-8.4devel-ready-for-testing.php

== PostgreSQL Jobs for November ==

http://archives.postgresql.org/pgsql-jobs/2008-11/threads.php

== PostgreSQL Local ==

PgDay Rio de la Plata is looking for sponsors.  Interested parties
should contact admin AT postgres-arg DOT org.

Dickson Guedes is looking for volunteers to help with a PgMeeting in
Florianópolis.  Write to guediz AT gmail DOT com if you want to help.

David Fetter will be speaking at PGDay Rio de la Plata Buenos Aires
November 22.
http://pgday.postgres-arg.org/

David Fetter will be speaking at OSDC Sydney December 3-5.
http://www.osdc.com.au/2008/index.html

FOSDEM 2009 will take place February 7-8 2009 in Brussels, Belgium.
PostgreSQL will share a booth with the BSD groups and have a developer
room.   Submit your 20-minute, 45 minute or lightning talks to
fosdem (at) postgresql (dot) org.

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.

== 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 at fetter.org, German language
to pwn at pgug.de, Italian language to pwn at itpug.org.

== Applied Patches ==

Teodor Sigaev committed:

- In pgsql/src/backend/utils/adt/tsvector_op.c, replace plain-memory
 ordered array by binary tree in ts_stat() function.  Performance is
 increased from 50% up to 10^3 times depending on data.

- In pgsql/src/backend/utils/adt/tsvector_op.c, fix compiler warning
 "res may be used uninitialized in this function".  Actually, it
 can't but some compilers are not smart enough.  Per Peter Eisentraut
 gripe.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/high-availability.sgml, document that Bucardo
 is an example of multi-master replication with conflict resolution.

- In pgsql/doc/src/sgml/high-availability.sgml, add "Most Common
 Implementation" row to high availablity table so the table is less
 abstract.  Most common implementations were already mentioned in the
 text.

- Issue a proper error message when MD5 is attempted when
 db_user_namespace is enabled.  Also document this limitation.

Peter Eisentraut committed:

- Ident authentication over Unix-domain sockets on Solaris, using
 getpeerucred() function.  Author: Garick Hamlin.

- In pgsql/src/bin/psql/create_help.pl, change this script to Perl 5
 style.  Add support for multiple refnames.  Sort the output by
 command name.  This previously only worked by source file name,
 which doesn't always match the command name exactly.  And it
 certainly won't work for multiple refnames.

- In pgsql/doc/src/sgml/ref/select.sgml, add WITH as a refname to the
 SELECT reference page.  Now "\help WITH" works and there will be a
 separate WITH(7) man page.

- Add SQL:2008 TABLE command.

- Use relation_expr for TABLE command, requested by Tom Lane.

- Include the platform "FAQs" into the installation instructions.  I
 weeded out some really old information along the way.  FAQ_AIX needs
 separate consideration and will be dealt with later.

Magnus Hagander committed:

- In pgsql/src/test/thread/thread_test.c, add required include to
 build with cygwin.  Andrew Chernow

- Control client certificate requesting with the pg_hba option
 "clientcert" instead of just relying on the root certificate file to
 be present.

- Add support for using SSL client certificates to authenticate to the
 database (only for SSL connections, obviously).

- In pgsql/src/test/regress/pg_regress.c, silence compiler warning
 about ignored return value. Our comment already clearly stated that
 we are aware that we're ignoring it.

- In pgsql/src/pl/plpgsql/src/pl_exec.c, don't pass strings directly
 to errdetail() and errhint() - use %s to unescape them. Fixes a
 potential security issue (in as yet unreleased code).

- Make the enumvals column of pg_settings be text[] instead of just a
 comma separated string.

- In pgsql/doc/src/sgml/catalogs.sgml, docs update for enumvals patch.

- In pgsql/doc/src/sgml/config.sgml, document which GUC settings are
 enums and not strings, along with a short paragraph about what that
 means.

- Fix a few more format argument warnings.

Tom Lane committed:

- Some infrastructure changes for the upcoming auto-explain contrib
 module: Refactor explain.c slightly to export a convenient-to-use
 subroutine for printing EXPLAIN results.  Provide hooks for plugins
 to get control at ExecutorStart and ExecutorEnd as well as
 ExecutorRun.  Add some minimal support for tracking the total
 runtime of ExecutorRun.  This code won't actually do anything unless
 a plugin prods it to.  Change the API of the DefineCustomXXXVariable
 functions to allow nonzero "flags" to be specified for a custom GUC
 variable.  While at it, also make the "bootstrap" default value for
 custom GUCs be explicitly specified as a parameter to these
 functions.  This is to eliminate confusion over where the default
 comes from, as has been expressed in the past by some users of the
 custom-variable facility.  Refactor GUC code a bit to ensure that a
 custom variable gets initialized to something valid (like its
 default value) even if the placeholder value was invalid.

- In pgsql/src/backend/utils/misc/guc.c, fix define_custom_variable so
 that SUSET custom variables behave somewhat reasonably.  It's not
 perfect, but it beats the kluge proposed in the auto-explain
 patch...

- Add auto-explain contrib module for automatic logging of the plans
 of slow-running queries.  Takahiro Itagaki.

- Fix breakage of bitmap scan plan creation for special index
 operators such as LIKE.  I oversimplified this code when removing
 support for plan-time determination of index operator lossiness back
 in April --- I had thought create_bitmap_subplan could stop
 returning two separate lists of qual conditions, but it still must
 so that we can treat special operators correctly in
 create_bitmap_scan_plan.  Per report from Rushabh Lathia.

- In pgsql/doc/src/sgml/xaggr.sgml, note that the example aggregate
 array_accum is comparable to the now built-in array_agg.  Per
 suggestion from Robert Haas.

- In pgsql/doc/src/sgml/config.sgml, minor copy-editing.

- Switch the planner over to treating qualifications of a JOIN_SEMI
 join as though it is an inner rather than outer join type.  This
 essentially means that we don't bother to separate "pushed down"
 qual conditions from actual join quals at a semijoin plan node;
 which is okay because the restrictions of SQL syntax make it
 impossible to have a pushed-down qual that references the inner side
 of a semijoin.  This allows noticeably better optimization of
 IN/EXISTS cases than we had before, since the equivalence-class
 machinery can now use those quals.  Also fix a couple of other
 mistakes that had essentially disabled the ability to unique-ify the
 inner relation and then join it to just a subset of the left-hand
 relations.  An example case using the regression database is
 SELECT * from tenk1 a, tenk1 b where (a.unique1,b.unique2) in
 (select unique1,unique2 from tenk1 c); which is planned reasonably
 well by 8.3 and earlier but had been forcing a cartesian join of a/b
 in CVS HEAD.

- In pgsql/src/backend/postmaster/bgwriter.c, teach
 RequestCheckpoint() to wait and retry a few times if it can't signal
 the bgwriter immediately.  This covers the case where the bgwriter
 is still starting up, as seen in a recent buildfarm failure.  In
 future it might also assist with clean recovery after a bgwriter
 termination and restart --- right now the postmaster treats early
 bgwriter exit as a system crash, but that might not always be so.

Heikki Linnakangas committed:

- Rethink the way FSM truncation works. Instead of WAL-logging FSM
 truncations in FSM code, call FreeSpaceMapTruncateRel from
 smgr_redo.  To make that cleaner from modularity point of view, move
 the WAL-logging one level up to RelationTruncate, and move
 RelationTruncate and all the related WAL-logging to new
 src/backend/catalog/storage.c file.  Introduce new
 RelationCreateStorage and RelationDropStorage functions that are
 used instead of calling smgrcreate/smgrscheduleunlink directly. Move
 the pending rel deletion stuff from smgrcreate/smgrscheduleunlink to
 the new functions. This leaves smgr.c as a thin wrapper around md.c;
 all the transactional stuff is now in storage.c.  This will make it
 easier to add new forks with similar truncation logic, like the
 visibility map.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Magnus Hagander sent in another revision of his patch to add a
clientcert option to pg_hba.conf.

Peter Eisentraut sent in a patch to redo xmlconcat() as a variadic
function.

Fujii Masao sent in another revision of his synchronous replication
patch.

ITAGAKI Takahiro sent in another revision of his auto_explain contrib
module.

Gregory Stark sent in another revision of his posix fadvise patch.

Marcus Kempe sent in a patch to add async notifications using dblink.

Magnus Hagander sent in three revisions of a patch to implement
wildcard SSL certificate matching in libpq.

Bruce Momjian sent in a patch to fix a bug wherein SSL callbacks are
not managed properly when other libraries are involved.

Martin Pihlak sent in another revision of his patch to implement an
SQL/MED compatible connection manager.

Heikki Linnakangas sent in another revision of his patch to add a
visibility map.

Euler Taveira de Oliveira sent in a patch to replace pg_autovacuum
with reloptions.

Ron Mayer sent in another revision of his patch to add interval style
to ECPG.

Alex Hunsaker sent in another revision of his SSL patch.


---------------------------(end of broadcast)---------------------------
-To unsubscribe from this list, send an email to:

              pgsql-announce-unsubscribe at postgresql.org



-- 
夏清然
Xia Qingran
qingran.xia at gmail.com
Samuel Goldwyn  - "I'm willing to admit that I may not always be right, but
I am never wrong."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.zeuux.org/pipermail/zeuux-postgresql/attachments/20081124/85cf4ec8/attachment-0001.html>