---------- Forwarded message ----------
From: David Fetter <david at fetter.org>
Date: Mon, Mar 16, 2009 at 11:48 AM
Subject: [ANNOUNCE] == PostgreSQL Weekly News - March 15 2009 ==
To: PostgreSQL Announce <pgsql-announce at postgresql.org>


== PostgreSQL Weekly News - March 15 2009 ==

Bug Fix Releases 8.3.7, 8.2.13, 8.1.17, 8.0.21 and 7.4.25 out soon.
Get ready to upgrade.

New Survey:  What programming language do you use with PostgreSQL?
www.postgresql.org/community

Lots of Pgdays are being planned in Brazil including Sao Paulo, Porto
Velho, Ji-Parana, and Brasilia.  Watch for more details next week!

Devrim GUNDUZ has released another set of snapshot RPMs.  Go forth and
test :)
http://yum.pgsqlrpms.org/news-8.4devel-ready-for-testing.php

French site 01.net chose PostgreSQL as the best Open Source database
ever.
http://www.01net.com/editorial/404090/postgresql-meilleure-base-de-donnees-open-source/

Watch for PostgreSQL video soon!

== PostgreSQL Product News ==

Jopr 2.2 beta 1, a server management and monitoring application, released.
http://pilhuhn.blogspot.com/2009/03/public-beta-of-jopr-22-released.html

pglesslog 1.2, a patch which reduces the size of WALs, released.
http://pglesslog.projects.postgresql.org/

Skytools 2.1.9, a Python-based replication system, released.
http://pgfoundry.org/projects/skytools/

== PostgreSQL 8.4 Feature of The Week ==

pg_stat_user_functions.  This new system view allows you to see which
functions were called, how many times, and time spent in the function
and in the functions it called.

== PostgreSQL Tip of the Week ==

Tip of the Week: pg_fouine processes PostgreSQL logs and summarizes
your slowest queries.  Current CVS code even works with comma-
separated values logs.

== PostgreSQL Jobs for March ==

http://archives.postgresql.org/pgsql-jobs/2009-03/threads.php

== PostgreSQL Local ==

The German PostgreSQL User Group will have a booth, 2 talks and a
workshop on the Linuxdays Chemnitz on March 14 and 15, 2009.  More
information in German here:
http://andreas.scherbaum.la/blog/archives/525-PostgreSQL-auf-den-Chemnitzer-Linuxtagen.html

PostgreSQLFr will have a booth at Solutions Linux 2009 March 31-April
2 in Paris.  Sign up with sas AT postgresql DOT fr or at the
French-language wiki:
http://postgresql.fr/sl2009:start

PostgreSQL Conference (JDCon) East 2009 registration is now open.
http://www.postgresql.us/purchase

Kevin Kempter will be speaking about backup and recover at Denver
PUG's first meeting on April 8, 2009.
http://www.diapug.org/Meeting.html

PostgreSQL Conference, U.S. will be holding a PgDay at LinuxFest
Northwest (April 25/26th). The call for papers is out at
http://www.postgresqlconference.org/

Michael Renner will be giving a PostgreSQL replication workshop at
Netways OSDC 2009 on April 29 and 30 in Nuremberg, Germany.
http://www.netways.de/english/osdc/y2009/programm/w/michael_renner_postgresql_repliziert_ein_ueberblick/

PGCon 2009 will be held 21-22 May 2009, in Ottawa at the University of
Ottawa.  It will be preceded by two days of tutorials on 19-20 May
2009.
http://www.pgcon.org/2009/

Save The Date: pgDay San Jose.  Sunday, July 19th 2009 immediately
before OSCON.  CfP, more info TBA!

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
and Josh Berkus.

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 ==

Bruce Momjian committed:

- In pgsql/src/backend/utils/time/tqual.c, add summarization comment
 about visibility functions.  Add URL about the Halloween problem.

- In pgsql/doc/src/sgml/monitoring.sgml, doc patch for the recently
 added probes.  Robert Lor

Peter Eisentraut committed:

- Accept 'on' and 'off' as input for boolean data type, unifying the
 syntax that the data type and GUC accepts.  ITAGAKI Takahiro

- Tweak the regression test case so that the ordering of numbers vs.
 letters doesn't matter.  This fixes failures in the Czech locale.

- In pgsql/src/backend/utils/adt/bool.c, in parse_bool_with_len, avoid
 crash when no result pointer is passed.  Probably an unlikely call
 mode, but better be safe.

- In pgsql/src/backend/po/ru.po, translation updates.

Teodor Sigaev committed:

- In pgsql/src/backend/tsearch/wparser_def.c, prevent recursion during
 parse of email-like string with multiple '@'.  Patch by Heikki
 Linnakangas.

- In pgsql/src/backend/tsearch/wparser_def.c, some languages have
 symbols with zero display's width or/and vowels/signs which are not
 an alphabetic character although they are not word-breakers too.
 So, treat them as part of word.  Per off-list discussion with
 Dibyendra Hyoju and and Bal Krishna Bal about the Nepali language
 and Devanagari alphabet.

Tom Lane committed:

- Fix set_subquery_pathlist() to copy the RTE's subquery before it
 gets mangled by the planning process.  This prevents the "failed to
 locate grouping columns" error recently reported by Dickson Guedes.
 That happens because planning replaces SubLinks by SubPlans in the
 subquery's targetlist, and exprTypmod() is smarter about the former
 than the latter, causing the apparent type of the subquery's output
 columns to change.  This seems to be a deficiency we should fix in
 exprTypmod(), but that will be a much more invasive patch with
 possible side-effects elsewhere, so I'll do that only in HEAD.
 Back-patch to 8.3.  Arguably the lack of a copying step is
 broken/dangerous all the way back, but in the absence of known
 problems I'll refrain from making the older branches pay the extra
 cost.  (The reason this particular symptom didn't appear before is
 that exprTypmod() wasn't smart about SubLinks either, until 8.3.)

- Make SubPlan nodes carry the result's typmod as well as datatype
 OID.  This is for consistency with the (relatively) recent addition
 of typmod to SubLink.  An example of why it's a good idea is to be
 seen in the recent "failed to locate grouping columns" bug, which
 wouldn't have happened if a SubPlan exposed the same typmod info as
 the SubLink it was derived from.  This could be back-patched, since
 it doesn't affect any on-disk data format, but for the moment it
 doesn't seem necessary to do so.

- In pgsql/src/backend/optimizer/path/indxpath.c, improve
 match_special_index_operator() to recognize that LIKE with an
 exact-match pattern (no wildcard) can be index-optimized in some
 cases where a prefix-match pattern cannot; specifically, since the
 required index clause is simple equality, it works for regular
 text/varchar indexes even when the locale is not C.  I'm not sure
 how often this case really comes up, but since it requires hardly
 any additional work to handle it, we might as well get it right.
 Motivated by a discussion on the JDBC list.

- Code review for dtrace probes added (so far) to 8.4.  Adjust
 placement of some bufmgr probes, take out redundant and
 memory-leak-inducing path arguments to smgr__md__read__done and
 smgr__md__write__done, fix bogus attempt to recalculate space used
 in sort__done, clean up formatting in places where I'm not sure
 pgindent will do a nice job by itself.

- In pgsql/src/backend/utils/adt/formatting.c, fix core dump due to
 null-pointer dereference in to_char() when datetime format codes are
 misapplied to a numeric argument.  (The code still produces a pretty
 bogus error message in such cases, but I'll settle for stopping the
 crash for now.)  Per bug #4700 from Sergey Burladyan.  Problem
 exists in all supported branches, so patch all the way back.  In
 HEAD, also clean up some ugly coding in the nearby cache management
 code.

- In pgsql/doc/src/sgml/release.sgml, update back-branch release
 notes.

- In pgsql/src/backend/storage/buffer/bufmgr.c, restore previous
 ordering of BUFFER_FLUSH_START probe.  I had wanted to make it
 include the time for the possible smgropen() call, but that results
 in a null pointer dereference :-(.  An alternative solution would be
 to fetch the buffer tag instead of looking at *reln, but I'll just
 put it back as it was for the moment.  BTW, this indicates that
 DTrace probes evaluate their arguments even when nominally inactive.
 What was that about "zero cost", again?

- In pgsql/src/bin/pg_dump/pg_backup_archiver.c, fix
 identify_locking_dependencies to reflect the fact that
 fix_dependencies previously repointed TABLE dependencies to TABLE
 DATA.  Mea culpa.

- Clean up the code for to_timestamp's conversion of year plus ISO day
 number to date, as per bug #4702 and subsequent discussion.  In
 particular, make it work for years specified using AD/BC or CC
 fields, and fix the test for "no year specified" so that it doesn't
 trigger inappropriately for 1 Bryce Cutt (which it was doing even in
 code paths that had nothing to do with to_timestamp).  I also did
 some minor code beautification in the non-ISO-day-number code path.
 This area has been busted all along, but because the code has been
 rewritten repeatedly, it would be considerable trouble to
 back-patch.  It's such a corner case that it doesn't seem worth the
 effort.

- Fix contrib/hstore to throw an error for keys or values that don't
 fit in its data structure, rather than silently truncating them.
 Andrew Gierth.

Alvaro Herrera committed:

- Remove pg_trace.h inclusion from c.h and add it to the .c files that
 need it.  Only needed in 8.3 because it's already this way in HEAD,
 and older branches did not support DTrace.  This allows external
 modules to compile on Linux machines where SystemTap support was
 recently added, when the required SystemTap headers are not present
 on the build machine.  Approach suggested by Tom Lane, after a RPM
 build trouble report by Devrim Gunduz.

Andrew Dunstan committed:

- Use thread-local storage for querybuffer in fmtId() on Windows, when
 needed (i.e. when running pg_restore, which might run in parallel).
 Only reopen archive file when we really need to read from it, in
 parallel code.  Otherwise, close it immediately in a worker, if
 possible.

Marc Fournier committed:

-  Tag 8.3.7, 8.2.13, 8.1.17, 8.0.21, and 7.4.25.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

KaiGai Kohei sent in three more revisions of his SE-PostgreSQL
patches.

Greg Sabino Mullane sent in a patch to remove the confusing -i and -d
switches from pg_dump, leaving only the long forms of what they used
to do.

ITAGAKI Takahiro sent in two revisions of a sampling profiler for 8.5.

Fujii Masao sent in another version of the PITR performance
improvement patch.

Alvaro Herrera sent in a patch to 8.3 which includes pg_trace.h only
in files that actually need it.


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

              pgsql-announce-unsubscribe at postgresql.org



-- 
$B2F at 6A3(B
Xia Qingran
qingran.xia at gmail.com
Sent from: Beijing 11 China.
Douglas Adams  - "I love deadlines. I like the whooshing sound they make as
they fly by."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.zeuux.org/pipermail/zeuux-postgresql/attachments/20090316/b09078b3/attachment-0001.html>