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

== Wöchentlicher PostgreSQL Newsletter - 12. September 2010 ==

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 - 12. September 2010 ==
Date: 2010-09-13 21:15:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-de-allgemein

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 12. September 2010 ==

Jonathan S. Katz wird über ORMs sprechen: Die Guten, die Schlechten und 
die Notwendigen (PostgreSQL wird einbezogen) bei der NYPUG am 13. 
September im Büro von Yodle. Details und Anmeldung unter:

Surge 2010, die Konferenz über Skalierbarkeit und Performance, findet in 
Baltimore, MD, USA vom 30. September bis zum 1. Oktober 2010 statt.

== PostgreSQL Produkt Neuigkeiten ==

Dataware Quick Application Suite 1.5, ein RAD Werkzeug, das
PostgreSQL unterstützt, ist erschienen.

pgbouncer 1.3.4, ein leichtgewichtiger Connectionpooler für
PostgreSQL, ist erschienen.

pgpool-II 3.0, ein Connection Pooler und mehr, und
pgpoolAdmin 3.0, ein GUI Administration Werkzeug dafür,
sind erschienen.

== PostgreSQL Jobs im September ==

== PostgreSQL Lokal ==

Der Call for Papers für den PGDay.EU 2010 am 6.-8. Dezember in
Stuttgart ist nun eröffnet.

== PostgreSQL in den News ==

Planet PostgreSQL:

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

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)

== Reviews ==

== Angewandte Patches ==

Bruce Momjian committed:

- Modify pg_upgrade to set/restore all environment variables related
   to collation/encoding to match English when reading controldata.
   This now matches the English variable setting used by pg_regress.c.
   Backpatch to 9.0.X.

- Doc fixes: 1. Remove excessive table cells.  2. Moving function
   parameters into function tags rather than having them being
   considered separate.  3. Add return type column on XML2 contrib
   module functions list and removing return types from function.  4.
   Add table header to XML2 contrib parameter table.  Thom Brown.
   Backpatch to 9.0.X.

- In pgsql/doc/src/sgml/backup.sgml, re-add documentation for Win32
   copy syntax for archive_command.  Backpatch to 9.0.X.

- In pgsql/doc/src/sgml/backup.sgml, don't try aligning comments for
   new archive_command Win32 doc example; it doesn't work.  Backpatch
   to 9.0.X.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/syntax.sgml, clarify that surrogate pairs are
   not encoded in UTF-8 directly.

- Add tip about building plpython 2 and 3.  Fix link to Python docs.

Tom Lane committed:

- In pgsql/doc/src/sgml/installation.sgml, remove obsolete claim that
   gzip is needed while installing PG's documentation.  It isn't, now
   that we ship the docs as loose files rather than a sub-tarball.
   Also adjust the wording in a couple of places to make the lists of
   required software read more consistently.

Michael Meskes committed:

- Cursor names in the backend are not case-sensitve.  This change
   makes sure that ecpg also does not regard cursor names as
   case-sensitive.  Thanks to Zoltan Boszormenyi for the patch.

Heikki Linnakangas committed:

- Introduce latches.  A latch is a boolean variable, with the
   capability to wait until it is set.  Latches can be used to reliably
   wait until a signal arrives, which is hard otherwise because signals
   don't interrupt select() on some platforms, and even when they do,
   there's race conditions.  On Unix, latches use the so called
   self-pipe trick under the covers to implement the sleep until the
   latch is set, without race conditions.  On Windows, Windows events
   are used.  Use the new latch abstraction to sleep in walsender, so
   that as soon as a transaction finishes, walsender is woken up to
   immediately send the WAL to the standby.  This reduces the latency
   between master and standby, which is good.  Preliminary work by
   Fujii Masao.  The latch implementation is by me, with helpful
   comments from many people.

- In pgsql/src/backend/port/unix_latch.c, add missing #includes,
   needed on some platforms.  This should make the unixware buildfarm
   animals happy again.

Joe Conway committed:

- SERIALIZABLE transactions are actually implemented beneath the
   covers with transaction snapshots, i.e. a snapshot registered at the
   beginning of a transaction.  Change variable naming and comments to
   reflect this reality in preparation for a future, truly serializable
   mode, e.g. Serializable Snapshot Isolation (SSI).  For the moment
   transaction snapshots are still used to implement SERIALIZABLE, but
   hopefully not for too much longer.  Patch by Kevin Grittner and Dan
   Ports with review and some minor wording changes by me.

Robert Haas committed:

- In pgsql/doc/src/sgml/catalogs.sgml, link from pg_shadow docs to
   pg_authid docs.  Per discussion with Josh Kupershmidt.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Dean Rasheed sent in two more revisions of the patch to add triggers
to views.

Thom Brown sent in a doc patch to fix some layout and markup issues.

Alvaro Herrera sent in a patch to fix a shortcoming in the
has_*_privilege() functions where PUBLIC wasn't a recognized role.

KaiGai Kohei sent in another patch to fix leaky views.

Teodor Sigaev sent in another revision of the patch for

Marko (johto) Tiikkaja sent in another revision of the patch to make
all query list snapshot handling work like EXPLAIN ANALYZE's code

Pavel Stehule sent in a patch intended to reduce the persistent
allocated memory for tsearch and ispell dictionaries.

Sushant Sinha sent in another revision of the patch to add support for
multiple words in the same position in text search.

Hans-Juergen Schoenig sent in a patch to add an RB tree library in a
place where it can help with searching large numbers of partitions.

Pavel Stehule sent in new versions of the format() and stringfunc

Joe Conway sent in another revision of the patch to differentiate
transaction isolation from serializable isolation in code and

Magnus Hagander sent in two revisions of a patch to fix the issue
where sometimes Windows processes return 128.

Tom Lane sent in a patch intended to help fix an issue with phantom
files for the CVS to git migration.

Fujii Masao sent in another revision of the patch to add synchronous

Fujii Masao sent in two revisions of a patch intended to fix an issue
where walsender doesn't process options passed in the startup packet.

			Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group:

pgsql-de-allgemein by date

Next:From: Andreas 'ads' ScherbaumDate: 2010-09-20 10:58:24
Subject: == Wöchentlicher PostgreSQL Newsletter - 19. September 2010 ==
Previous:From: Andreas WenkDate: 2010-09-08 20:15:47
Subject: Re: PostgreSQL Artikel online - PDF

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