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

== Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 ==

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 - 27. Juli 2008 ==
Date: 2008-07-28 11:11:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-de-allgemein
Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 ==

Das Juli Commitfest ist fast vorüber und viele neue Features wurden

== PostgreSQL Produkt Neuigkeiten ==

Benetl 2.2 erschienen.

check_postgres 2.1.0 erschienen.

pgpool-II 2.1 erschienen.

== PostgreSQL Jobs im Juli ==

== PostgreSQL Lokal ==

Sponsere den Europäischen PostgreSQL Tag!

Der Call for Papers für den Europäischen PostgreSQL Tag hat begonnen.

pgDay San Francisco wird am 5. August stattfinden. Programm:
Anmeldung hier:

PGCon Brazil 2008 wird vom 26.-27. September auf dem Unicamp in
Campinas stattfinden.

PGDay.(IT|EU) 2008 wird am 17. und 18. Oktober in Prato stattfinden.

== PostgreSQL in den News ==

Planet PostgreSQL:

General Bits, Archive und gelegentliche News Artikel:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David

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

Tom Lane committed:

- In pgsql/src/backend/commands/prepare.c, add comment about the two
  different query strings that ExecuteQuery() has to deal with.

- In pgsql/doc/src/sgml/gin.sgml, update link to Oleg and Teodor's GIN
  page.  (Extracted from fast-insert patch, since it ought to be

- Use guc.c's parse_int() instead of pg_atoi() to parse fillfactor in
  default_reloptions().  The previous coding was really a bug because
  pg_atoi() will always throw elog on bad input data, whereas
  default_reloptions is not supposed to complain about bad input
  unless its validate parameter is true.  Right now you could only
  expose the problem by hand-modifying pg_class.reloptions into an
  invalid state, so it doesn't seem worth back-patching; but we should
  get it right in HEAD because there might be other situations in
  future.  Noted while studying GIN fast-update patch.

- In pgsql/src/backend/libpq/hba.c, remove some redundant tests and
  improve comments in next_token().  Cosmetic, but it might make this
  a bit less confusing to the next reader.

- In pgsql/src/backend/libpq/auth.c, fix parsing of LDAP URLs so it
  doesn't reject spaces in the "suffix" part.  Per report from Cesar
  Miguel Oliveira Alves.

- As noted by Andrew Gierth, there's really no need any more to force
  a junk filter to be used when INSERT or SELECT INTO has a plan that
  returns raw disk tuples.  The virtual-tuple-slot optimizations that
  were put in place awhile ago mean that ExecInsert has to do
  ExecMaterializeSlot, and that already copies the tuple if it's raw
  (and does so more efficiently than a junk filter, too).  So get rid
  of that logic.  This in turn means that we can throw away
  ExecMayReturnRawTuples, which wasn't used for any other purpose, and
  was always a kluge anyway.  In passing, move a couple of
  SELECT-INTO-specific fields out of EState and into the private state
  of the SELECT INTO DestReceiver, as was foreseen in an old comment
  there.  Also make intorel_receive use ExecMaterializeSlot not
  ExecCopySlotTuple, for consistency with ExecInsert and to possibly
  save a tuple copy step in some cases.

Alvaro Herrera committed:

- In pgsql/src/backend/postmaster/autovacuum.c, publish more openly
  the fact that autovacuum is working for wraparound protection.
  Simon Riggs.

- In pgsql/src/backend/postmaster/autovacuum.c, ratchet up patch to
  improve autovacuum wraparound messages.  Simon Riggs.

Peter Eisentraut committed:

- Abort if Tcl support was configured and no tcl shell was found.
  This is required because the value is substituted into the
  pltcl_*mod scripts.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Markus Wanner sent in a patch to rename query_string to prepared_qs.

Robert Lor sent in a revised patch for dtrace probes.

David Gould sent in a patch for pg_dumpall which adds a
--lock-wait-timeout parameter similar to the one he added for pg_dump.

Simon Riggs sent in revision of his patch to make autovacuum report
when it is preventing a transaction ID wraparound for CVS HEAD and

Simon Riggs sent in two more revisions of a patch to add
--schema-before-data and --schema-after-data options to pg_dump.

Xiao Meng sent in another version of his patch to improve performance
on hash indexes.

Robert Haas sent in a patch to add a separate permission for TRUNCATE.

Tatsuo Ishii sent in three more revisions of Yoshiyuki Asaba's patch
to implement CTEs.

Simon Riggs sent a patch to add a contrib module which adds a
Transportable Optimizer Mode to PostgreSQL.

		Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group:

pgsql-de-allgemein by date

Next:From: Oliver BaerDate: 2008-07-31 21:27:22
Subject: In Funktion prüfen ob Zeile existiert
Previous:From: Markus WannerDate: 2008-07-22 14:00:20
Subject: Re: Artikel im Linux Technical Review: Datenbanken

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