[DPWN] Wöchentlicher PostgreSQL Newsletter - 04. März 2007

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 04. März 2007 ==

Eine europäische PostgreSQL Gruppe formiert sich. Passt auf baue Plüschelefanten auf

== PostgreSQL Produkt Neuigkeiten ==

PGCluster 1.5.0rc16 & 1.7.0rc5 erschienen.

Orafce 2.1.1 erschienen, jetzt kompatibel mit 8.1.8, 8.2.3 und CVS HEAD.

pgmemcache 1.2beta1 erschienen.

Mysql2pgsql 1.2 erschienen, jetzt mit Bugfixes.

== PostgreSQL Lokal ==

Die Deutsche PostgreSQL Usergroup war mit einem Stand auf dem Linuxtag in Chemnitz vertreten. Die Präsentation war sehr erfolgreich, mit vielen interessanten Gesprächen und Feedback von vielen Usern, die PostgreSQL bereits einsetzen. Wir werden auf dem nächsten CLT wieder präsent sein.

Die italienische PostgreSQL Community ist auf der Suche nach Sponsoren
für ihren PostgreSQL Tag in Prato, Italien im Sommer. Mehr
Informationen unter untenstehendem Link.

== PostgreSQL in den News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archive und gelegentliche News Artikel:

Lorenzo Alberton hat ein Tutorial über Table Auditing geschrieben.

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Devrim GUNDUZ.

Um deine Beiträge für die nächste Ausgabe zu übermitteln, sende diese
an david@fetter.org oder in Deutsch an pwn@pgug.de bis Sonntag, 15:00 Uhr Pazifischer Zeit.
== Angewandte Patches ==

Neil Conway committed

  • A patch which adds a resetStringInfo() method to the StringInfo API
    and fixes various parts of the tree that were clearing a StringInfo
    by hand. Making this function a part of the API simplifies client
    code slightly, and avoids needlessly peeking inside the StringInfo

Peter Eisentraut committed:

  • Pavel Stehule’ patch which fixes date/time formats for XML Schema

Bruce Momjian committed:

  • Jeremy Drake’s patch which changes the large object regression test
    to look more like the C it talks to by using hex representations
    directly instead of baroque expressions with arithmetic on powers of
  • Heikki Linnakangas’s patch which splits _bt_insertonpg to two

  • Simon Riggs’s fix for COPY-after-truncate feature.

  • Florian G. Pflug’s patch which removes the undo information from
    pg_controldata — never used.

  • Kris Jurka’s patch which adds lo_truncate() to backend and libpq for
    large object truncation.

  • Darcy Buskermolen’s patch which adds logging to /contrib/pg_standby
    if -k couldn’t clean up the log file.

  • Simon Riggs’ patch which add GUC log_lock_waits to log long wait

  • In TODO, mark as done, “Allow psql \pset boolean variables to set to
    fixed values, rather than toggle.”

  • Chad Wagner’s patch to psql which allows \pset, \x and \t to use
    boolean constants on/off, rather than just toggle.

  • Update license wording in FAQ_DEV.

  • Add TODO URLs for “Add REPLACE or UPSERT command that does UPDATE,
    or on failure, INSERT [merge].”

  • In FAQ_DEV, fix HTML markup.

  • In FAQ_DEV, mention we don’t want non-BSD-compatible licensed

  • Add language about rights given by posting a patch to FAQ_DEV.

  • In FAQ_DEV, update release timeline to use unnumber lists HTML.

  • Robert Treat’s update to DEV FAQ for CVS/SVN issue.

Magnus Hagander committed:

  • Remove temporary Windows-specific debugging code from

  • In pgsql/src/tools/msvc/build.bat, make build.bat return a proper
    errorcode if the build fails.

Michael Meskes committed:

  • In pgsql/src/interfaces/ecpg/ecpglib/execute.c, back-port fix of bug
    2956, where ECPG mis-handled multi-byte characters.

Tom Lane committed:

  • Make log_min_error_statement put LOG level at the same priority as
    log_min_messages does; and arrange to suppress the duplicative
    output that would otherwise result from log_statement and
    log_duration messages. Bruce Momjian and Tom Lane.

  • In pgsql/doc/src/sgml/array.sgml, fix broken markup, improve

  • Heikki Linnakangas and Tom Lane’s patch which suppresses useless
    searches for unused line pointers in PageAddItem. To do this, add a
    16-bit “flags” field to page headers by stealing some bits from
    pd_tli. We use one flag bit as a hint to indicate whether there are
    any unused line pointers; the remaining 15 are available for future
    use. This is a cut-down form of an idea proposed by Hiroki Kataoka
    in July 2005. At the time it was rejected because the original
    patch increased the size of page headers and it wasn’t clear that
    the benefit outweighed the distributed cost. The flag-bit approach
    gets most of the benefit without requiring an increase in the page
    header size.

  • In pgsql/src/backend/postmaster/pgstat.c, fix miscalculation of
    stats collector’s write delay, introduced in revision 1.117.

  • Fix markQueryForLocking() to work correctly in the presence of
    nested views. It has been wrong for this case since it was first
    written for 7.1

Per report from Pavel Hanak.

  • Fix up several contrib modules that were using varlena datatypes in
    not-so-obvious ways. I’m not totally sure that I caught everything,
    but at least now they pass their regression tests with
    VARSIZE/SET_VARSIZE defined to reverse byte order.

  • Gregory Stark and Tom Lane’s patch which replaces direct assignments
    to VARATT_SIZEP(x) with SET_VARSIZE(x, len). Get rid of VARATT_SIZE
    and VARATT_DATA, which were simply redundant with VARSIZE and
    VARDATA, and as a consequence almost no code was using the longer
    names. Rename the length fields of struct varlena and various
    derived structures to catch anyplace that was accessing them
    directly; and clean up various places so caught. In itself this
    patch doesn’t change any behavior at all, but it is necessary
    infrastructure if we hope to play any games with the representation
    of varlena headers.

  • Get rid of the separate EState for subplans, and just let them share
    the parent query’s EState. Now that there’s a single flat
    rangetable for both the main plan and subplans, there’s no need
    anymore for a separate EState, and removing it allows cleaning up
    some crufty code in nodeSubplan.c and nodeSubqueryscan.c. Should be
    a tad faster too, although any difference will probably be hard to
    measure. This is the last bit of subsidiary mop-up work from
    changing to a flat rangetable.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week

== Eingesandte Patches ==

Gregory Stark sent in an update patch which fixes a rather critical
oversight which caused the earlier compacting-varlena patches all to
appear to work but not actually to save any space.

Gregory Stark sent in a patch which adds a special case representation
for NUMERICs that can be represented in less than 8 bytes to do so
when possible. Numbers with a decimal point in them are still stored
as two numbers.

ITAGAKI Takahiro sent in another version of his “load distributed
checkpoint” patch.

John Bartlett sent in a work-in-progress patch for updateable cursors.

Zoltan Boszormenyi sent in two more revisions of his

Chris Marcellino sent in two more versions of his POSIX shared memory

Gregory Stark sent in another revision of his packed varlena patch
which updates it for the SET_VARZSIZE changes.

Kris Jurka updated his lo_truncate patch to work with the new packed

ITAGAKI Takahiro sent in another revision of his work-in-progress
patch for dead space map.

Heikki Linnakangas sent in a patch intended to speed up COPY.

Pavan Deolasee sent in version 4.0 of his work-in-progress HOT
(highly-updated tuples) patch.

Zum Artikel im Blog…

Datum: Mon, 05 Mar 2007 11:26:44 +0100