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

Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/

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

Eine lebhafte Diskussion ist auf -hackers in Gange über das automatische Erstellen von Partitionen.

== PostgreSQL Produkt Neuigkeiten ==

Phil Endecott hat neue C++ Bindings für PostgreSQL erstellt.
http://svn.chezphil.org/libpbe/trunk/doc/Database

Security Enhanced PostgreSQL (SE-PostgreSQL) 8.2.3-1.0 alpha erschienen.
http://code.google.com/p/sepgsql/

Slony-I 1.1.7 und 1.2.7 erschienen.
http://main.slony.info/

== PostgreSQL Jobs für März ==

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

== PostgreSQL Lokal ==

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.
http://www.pgday.it

== PostgreSQL in den News ==

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

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fetter

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

Andrew Dunstan committed:

  • In pgsql/src/test/regress/output/largeobject_1.source, add alternate
    result file for large object tests to handle Windows line ends.

Teodor Sigaev committed:

  • Athough cube is a varlena type, nowhere was a detoasting of cube’s
    value, so fix it. Add macroses DatumGetNDBOX, PG_GETARG_NDBOX and
    PG_RETURN_NDBOX. Backpatch for 8.2 too. Previous versions use
    version 0 calling conventions. And fmgr code detoast values for
    user-defined functions.

Alvaro Herrera committed:

  • Fix a race condition that caused pg_database_size() and
    pg_tablespace_size() to fail if an object was removed between calls
    to ReadDir() and stat(). Per discussion in pgsql-hackers.
    http://archives.postgresql.org/pgsql-hackers/2007-03/msg00671.php
    Bug report and patch by Michael Fuhr.

  • Clean up the bootstrap code a little, and rename “dummy procs” in
    the code comments and variables to “auxiliary proc”, per Heikki’s
    request.

Tom Lane committed:

  • Fix vac_update_relstats to ensure it always sends a relcache inval
    message, even if none of the fields in the pg_class row change.
    This behavior is necessary to ensure other backends flush
    rd_targblock values that might point to truncated-away pages. We
    got this right pre-8.2 but it was broken by overoptimistic change to
    not write out the pg_class row if unchanged. Per report from Pavan
    Deolasee.

  • Fix oversight in original coding of inline_function(): since
    check_sql_fn_retval allows binary-compatibility cases, the
    expression extracted from an inline-able SQL function might have a
    type that is only binary-compatible with the declared function
    result type. To avoid possibly changing the semantics of the
    expression, we should insert a RelabelType node in such cases. This
    has only been shown to have bad consequences in recent 8.1 and up
    releases, but I suspect there may be failure cases in the older
    branches too, so patch it all the way back. Per bug #3116 from Greg
    Mullane. Along the way, fix an omission in
    eval_const_expressions_mutator: it failed to copy the relabelformat
    field when processing a RelabelType. No known observable failures
    from this, but it definitely isn’t intended behavior.

Peter Eisentraut committed:

  • Toru SHIMOGAKI’s patch which adds more information about avoiding
    Linux OOM killer.

Bruce Momjian committed:

  • Minor edits to pgsql/doc/src/sgml/runtime.sgml

  • Revert temp_tablespaces because of coding problems, per Tom Lane.

  • In pgsql/src/backend/utils/adt/geo_ops.c, remove copied comments
    from geo_ops.c source file and replace with new comments, and
    cleanup functions. Remove copyright that is no longer relevant.

  • Remove timeline for 8.3 release from FAQ_DEV, as it is now on web
    site.

Magnus Hagander commmitted:

  • Remove unsafe calling of WSAStartup and WSACleanup from DllMain.
    Move the inline cleanup call around so it will be called in the
    right order, and be called on errors. Per report from Tokuharu
    Yuzawa.

  • Add script to build documentation on win32 without mingw.

  • Remove old-style win32 client-only visual c++ build infrastructure
    for everything except libpq. We need to keep libpq to build static
    libraries and to use PQtrace with clients using older versions of
    MSVC.

Neil Conway committed:

  • Heikki Linnakangas patch which fixes a typo in a comment in
    pgsql/src/backend/access/nbtree/nbtinsert.c.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week

== Eingesandte Patches ==

Zoltan Boszormenyi sent in one more version of his IDENTITY/GENERATED
patch.

Nikolay Samokhvalov sent in another version of his xpath_array()
patch.

ITAGAKI Takahiro sent in a patch which automatically adjusts
bgwriter_lru_maxpages.

ITAGAKI Takahiro sent in a patch to speed up pg_bench.

Simon Riggs sent in a patch which lets people do some heap page
diagnostics.

Mike Rylander sent in a patch against contrib/xml2 which adds support
for default XML namespaces.

Trevor Hardcastle sent in a patch which adds support for CREATE TABLE
LIKE INCLUDING INDEXES.

Tatsuhito Kasahara sent in a patch to fix a bug reporting a value of
strange leaf_fragmentation.

Pavan Deolasee sent in version 4.1 of his HOT WIP patch, this one with
some optimizations for efficiently looking up LP_DELETEd tuples and
some new logic to clean up row level fragmentation.

Gregory Stark sent in another version of his packed varlenas patch,
now with bug fixes and new regression tests.

Simon Riggs sent in a patch to add new functions that examine the
contents of heap pages, as discussed recently on -hackers.

Simon Riggs sent in a patch which adds a new GUC variable:
log_autovacuum.

Simon Riggs sent in two versions of a patch to implement buffer cache
recycling for scans, as being discussed on pgsql-hackers.

Gregory Stark sent in a patch which implements WITH (not RECURSIVE).

Gregory Stark sent in another version of his compact varlena patch,
now with a special case for little-endian machines.

Heikki Linnakangas sent in a patch documenting that CLUSTER isn’t
MVCC-safe.

Tom Lane sent in a WIP patch for plan invalidation.


Zum Artikel im Blog…

Datum: Mon, 12 Mar 2007 10:06:11 +0100