Skip site navigation (1) Skip section navigation (2)

== Wöchentlicher PostgreSQL Newsletter - 29. November 2009 ==

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-de-allgemein(at)postgresql(dot)org <pgsql-de-allgemein(at)postgresql(dot)org>
Cc: pgusers(at)postgres(dot)de <pgusers(at)postgres(dot)de>
Subject: == Wöchentlicher PostgreSQL Newsletter - 29. November 2009 ==
Date: 2009-12-02 21:20:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-de-allgemein
Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 29. November 2009 ==

PostgreSQL RPM Pakete für Fedora-12 released:

== PostgreSQL Produkt Neuigkeiten ==

apgdiff 1.4, ein Werkzeug zum Vergleichen von PostgreSQL
Schemata, ist erschienen.

Karoo, ein webbasiertes GUI basierend auf PostgreSQL, ist erschienen.

MyJSQLView 3.05, ein Java-basierendes GUI for PostgreSQL, released.

== PostgreSQL Jobs im November ==

== PostgreSQL Lokal ==

Der dritte Italienische PostgreSQL Tag wird an der Universität von
Pisa am 4. Dezember stattfinden. Der Eintritt ist frei. Sponsoren
sind willkommen.

Stefan Keller gibt einen Kurs "Einführung in PostGIS/PostgreSQL" an
der HSR Hochschule für Technik Rapperswil (HSR) am 14. Januar 2010
in Zürich, Schweiz.

FOSDEM 2010 findet am 6. und 7. Februar 2010 in Brüssel,
Belgien statt.

Die Chemnitzer Linuxtage finden am 13. und 14. März in
Chemnitz, Deutschland statt.

== PostgreSQL in den News ==

Planet PostgreSQL:

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

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Heikki Linnakangas committed:

- Fix an old bug in multixact and two-phase commit.  Prepared
  transactions can be part of multixacts, so allocate a slot for each
  prepared transaction in the "oldest member" array in multixact.c.  On
  PREPARE TRANSACTION, transfer the oldest member value from the
  current backends slot to the prepared xact slot.  Also save and
  recover the value from the 2PC state file.  The symptom of the bug
  was that after a transaction prepared, a shared lock still held by
  the prepared transaction was sometimes ignored by other
  transactions.  Fix back to 8.1, where both 2PC and multixact were

Magnus Hagander committed:

- In pgsql/src/interfaces/libpq/win32.mak, add missing library to
  standalone libpq build on Win32.  Hiroshi Saito.

Tom Lane committed:

- Use diff's -w switch only on Windows, to avoid problems with
  inconsistent newline representations.  Per buildfarm results and
  subsequent discussion.  Sync up a couple of other places that had
  their own policies.

- Simplify psql's new linestyle behavior to default to linestyle=ascii
  all the time, rather than hoping we can tell whether the terminal
  supports UTF8 characters.  Per discussion.

- In pgsql/doc/src/sgml/release-8.5.sgml, fix missing end tag, per
  Jeff Davis.

- Eliminate a lot of list-management overhead within
  join_search_one_level by adding a requirement that build_join_rel
  add new join RelOptInfos to the appropriate list immediately at
  creation.  Per report from Robert Haas, the list_concat_unique_ptr()
  calls that this change eliminates were taking the lion's share of
  the runtime in larger join problems.  This doesn't do anything to
  fix the fundamental combinatorial explosion in large join problems,
  but it should push out the threshold of pain a bit further.  Note:
  because this changes the order in which joinrel lists are built, it
  might result in changes in selected plans in cases where different
  alternatives have exactly the same costs.  There is one example in
  the regression tests.

- Add support for an application_name parameter, which is displayed in
  pg_stat_activity and recorded in log entries.  Dave Page, reviewed
  by Andres Freund.

- Add support for anonymous code blocks (DO blocks) to PL/Perl.  Patch
  by Joshua Tolley, reviews by Brendan Jurd and Tim Bunce.

- Make pg_stat_activity.application_name visible to all users, rather
  than being hidden when current_query is.  Relocate it to a column
  position more consistent with that behavior.  Per discussion.

- Add some opr_sanity checks that the lengths of the various
  argument-info arrays in a pg_proc entry match.  Seems like an easy
  mistake to make when manually adjusting these values in a pg_proc.h

- In pgsql/src/pl/plperl/plperl.c, fix session-lifespan memory leak
  when a plperl function is redefined: we have to tell Perl it can
  release its compiled copy of the function text.  Noted by Alexey
  Klyukin.  Back-patch to 8.2 --- the problem exists further back, but
  this patch won't work without modification, and it's probably not
  worth the trouble.

Peter Eisentraut committed:

- Add PG_MODULE_MAGIC and some missing include files to examples.
  Euler Taveira de Oliveira.

- In pgsql/doc/src/sgml/func.sgml, fix syntax in extract() examples.
  Erik Rijkers.

- In pgsql/src/interfaces/libpq/fe-connect.c, remove prefix "ERROR:"
  from some messages, to make everything consistent

- In pgsql/src/interfaces/libpq/fe-connect.c, error when a specified
  connection service is not found, instead of ignoring it.

Michael Meskes committed:

- In pgsql/src/interfaces/ecpg/ecpglib/misc.c, made function better

- Added dynamic cursor names to ecpg. Almost the whole patch was done
  by Boszormenyi Zoltan, with only a minor tweak or two from me.

- In pgsql/src/interfaces/ecpg/preproc/ecpg.addons, synced addon rules
  after some renamings.

- In pgsql/src/interfaces/ecpg/ChangeLog, forgot to add dynamic
  cursors to Changelog.

- In ECPG, added missing files.

- In ECPG, added script to check if all rule re-definition in
  ecpg.addons are indeed used in the build process. If not the build
  process will stop with an error message.

- In pgsql/src/interfaces/ecpg/ecpglib/data.c, if no result is given
  NOTFOUND should be returned. Check for empty result string too.

- In pgsql/src/interfaces/ecpg/preproc/ecpg.addons, remove */
  characters from declare cursor statements before putting them into a

Bruce Momjian committed:

- In pgsql/doc/src/sgml/ref/vacuumdb.sgml, document ath vacuumdb
  --analyze does analyze _also_, not in place of vacuum.

- Improve test descriptions displayed during test_fsync;  increase
  default loops to 5k.

- Add link to external fsync testing script and our fsync test tool.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Marko (johto) Tiikkaja sent in another revision of the writeable CTE
patch.  Tom Lane responded with another one.

Teodor Sigaev sent in a patch to add red-black trees to GIN.

Teodor Sigaev sent in a patch to add some point operations for GiST.

Teodor Sigaev sent in a patch to add a supplied module which does
K-nearest-neighbor efficiently using GiST.

Alexey Klyukin sent in a patch to improve PL/Perl's support for
PostgreSQL arrays.

Daniel Farina sent in a group of patches to allow COPY TO FUNCTION and
add support to same to dblink.

Andrew Dunstan sent in a patch to allow ragged COPYing.

Per a review by Jeff Janes, ITAGAKI Takahiro sent in another revision
of the patch to add a BUFFERS option to EXPLAIN.

Tim Bunch sent in two revisions of a patch refactoring PL/Perl[U] per

Zdenek Kotala sent in a patch to refactor the path Docbook uses so it
works better on Solaris.

Jeff Davis sent on three more revisions of the operator exclusion
constraints patch.

ITAGAKI Takahiro sent in another revision of the partitioning syntax

Magnus Hagander sent in a patch to add git to the PostgreSQL official

Teodor Sigaev sent in two revisions of a WIP patch to add
k-nearest-neighbor searches to GiST.

Robert Haas sent in another revision of the patch to allow people to
set random_page_cost and seq_page_cost per tablespace.

Simon Riggs sent in a patch to fix some issues in hot standby.

Jeff Davis sent in a doc patch atop the new VACUUM FULL patch.

Hitoshi Harada sent in another revision of the patch to add more ROWS
options for frames in windowing functions.

Magnus Hagander sent in a patch to fix LDAP.

Kurt Harriman sent in a patch to remove a gcc dependency in the
definition of inline functions.

			Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group:

pgsql-de-allgemein by date

Next:From: Andreas 'ads' ScherbaumDate: 2009-12-07 15:35:10
Subject: == Wöchentlicher PostgreSQL Newsletter - 06. Dezember 2009 ==
Previous:From: Hans-Jürgen SchönigDate: 2009-11-25 16:34:22
Subject: Re: Jemand an der datacon'09?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group