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

== Wöchentlicher PostgreSQL Newsletter - 09. Dezember 2007 ==

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 - 09. Dezember 2007 ==
Date: 2007-12-10 13:36:25
Message-ID: 20071210143625.7ad6071f@iridium.wars-nicht.de (view raw or flat)
Thread:
Lists: pgsql-de-allgemein

Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/index.php?/archives/148-Postgres-Weekly-News-December-09-2007.html


== Wöchentlicher PostgreSQL Newsletter - 09. Dezember 2007 ==

8.3 Beta 4 ist erschienen. Bitte mit dem Testen fortfahren :)

FISL 9.0 wird vom 17.-19. April 2008 in PUCRS in Porto Alegre,
Brailien, stattfinden. Talks sind bis zum 17. Dezember zu übermitteln.
Entschuldigung für die späte Nachricht.
https://fisl.softwarelivre.org/9.0/papers/speaker/

Um bei der italienischen Übersetzung der PostgreSQL Dokumentation zu
helfen, besuche:
https://labs.psql.it/wiki/Traduzioni

Entwickler Umfrage: hilf die PostgreSQL Anzahl zu vergrößern!
http://solutions.internet.com/index.php/4431_default/d06d68c39e4b77545d082da8d2ea5d86

PgCon.br war ein voller Erfolg mit mehr als 200 Teilnehmern.
http://www.postgresql.org.br/encontronacionalpostgresql

Xing hat jetzt eine PostgreSQL Gruppe:
https://www.xing.com/net/postgresql

== PostgreSQL Produkt Neuigkeiten ==

Das Projekt zur Verbesserung von Full-page Writes ist erschienen:
http://pgfoundry.org/projects/pglesslog/

2ndQuadrant hat jetzt einen PostgreSQL Performance Kurs.
http://www.2ndquadrant.com/training.html

pgloader 2.2.5 erschienen.
http://pgfoundry.org/projects/pgloader/

PostGis 1.3.2 erschienen.
http://www.postgis.org/

== PostgreSQL Jobs im Dezember ==

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

== PostgreSQL Lokal ==

PGCon 2008 Call for Papers startet am 19. Dezember. Jetzt mit den
Papers beginnen.
http://www.pgcon.org/2008/papers.php

Die BSD und PostgreSQL Teams haben einen gemeinsamen Developer Room auf
der FOSDEM 2008 in Brüssel. Wenn du einen Vortrag halten möchtest oder
beim Managing des Rooms helfen möchtest, kontaktiere fosdem(at)pgug(dot)eu(dot)
Für mehr Informationen siehe:
http://fosdem.org/2008/schedule/devroom/bsdpostgresql

PostgreSQL Conference East '08 ist am 28. und 29. März.
http://www.postgresqlconference.org/

== 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 Berkus, Devrim GUNDUZ and Enrico Pirozzi.

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

Bruce Momjian committed:

- In pgsql/doc/src/sgml/release.sgml, change documentation, change
  "distributed" checkpoints to "smoothed" checkpoints.

- In pgsql/doc/src/sgml/release.sgml, update HOT description to make
  index column changes clearer.

- Remove completed 8.3 TODO items.

- In release notes, mention "most" updates are improved with HOT.

- In the release notes, mention that the "Overview" items are listed
  in the sections below in more detail.

- FAQ wording and markup fix.  Euler Taveira de Oliveira.

- Update Brazilian FAQ.  Euler Taveira de Oliveira

Alvaro Herrera committed:

- Change wording of logged message when cancelling an autovacuum task,
  using american speling (unlike this commit message).  Per complaint
  from Mike C. on bug #3790 and subsequent discussion.

- In pgsql/doc/src/sgml/release.sgml, change the "distributed
  checkpoint" release note item to Greg Smith's proposed wording.

Peter Eisentraut committed:

- Remove unused, occasionally confusing graphics building support from
  pgsql/doc/src/sgml/Makefile.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, Realign the
  running text in this file to 79 characters wide.  Some other
  copy-editing.

Magnus Hagander committed:

- In pgsql/doc/src/sgml/protocol.sgml, add missing documentation for
  SSPI packets.

- In pgsql/src/tools/msvc/Install.pm, don't try to install README.spi.
  Hannes Eder.

- In pgsql/src/tools/msvc/config.pl, default to integer timestamps
  being off until 8.4, to correspond to the settings used for other
  platforms.

- In pgsql/src/interfaces/libpq/fe-auth.c, on't send an empty SSPI
  negotiation packet at the end of the negotiation.  Fixes bug #3750

- Disable asserts by default on msvc build (to make it the same as in
  unix)

Tom Lane committed:

- Update SGML contrib documentation to catch up with recent changes to
  the former README files.  Albert Cervera i Areny

- Add SGML documentation for contrib/spi and contrib/test_parser.  The
  spi documentation is pretty rudimentary, but it's a start.

- Remove obsoleted README files.

- Improve partitioning example, per Itagaki Takahiro.

- Remove contrib/spi/preprocessor, which has been uninteresting ever
  since we supported standard FOREIGN KEY constraint syntax.  It was
  harmless enough just sitting there, but the prospect of having to
  document it is surely more work than it's worth.

- In pgsql/src/backend/optimizer/plan/planagg.c, fix
  build_minmax_path() to cope if an IS NULL clause turns up in the
  indexable-clauses list for a btree index.  Formerly it just Asserted
  that all such clauses were opclauses, but that's no longer true in
  8.3.  Per bug #3796 from Matthias Schoeneich.

- Entity-ify a passel of & < > characters.  Per gripe from Devrim.

- Correct misattribution of earthdistance module --- according to its
  old README file, Bruno Wolff did the bulk of the work, but for some
  reason only Hal Snyder was credited here.

- Make an editorial pass over the newly SGML-ified contrib
  documentation.  Fix lots of bad markup, bad English, bad
  explanations.  This commit covers only about half the contrib
  modules, but I grow weary...

- Add missing table entry for lastval(), per Jeff Davis.

- In pgsql/contrib/tablefunc/tablefunc.c, clean up a couple of
  problems in crosstab_hash's use of a hash table.  The original
  coding leaked memory (at least 8K per crosstab_hash call) because it
  allowed the hash table to be allocated as a child of
  TopMemoryContext and then never freed it.  Fix that by putting the
  hash table under per_query_ctx, instead.  Also get rid of use of a
  static variable to point to the hash table.  Aside from being ugly,
  that would actively do the wrong thing in the case of re-entrant
  calls to crosstab_hash, which are at least theoretically possible
  since it was expecting the static variable to stay valid across a
  SPI_execute call.

- Fix mergejoin cost estimation so that we consider the statistical
  ranges of the two join variables at both ends: not only trailing
  rows that need not be scanned because there cannot be a match on the
  other side, but initial rows that will be scanned without possibly
  having a match.  This allows a more realistic estimate of startup
  cost to be made, per recent pgsql-performance discussion.  In
  passing, fix a couple of bugs that had crept into mergejoinscansel:
  it was not quite up to speed for the task of estimating
  descending-order scans, which is a new requirement in 8.3.

- Fix completely-bogus volatility markings on pg_trgm functions.

- Fix up the PQconnectionUsedPassword mess: create a separate
  PQconnectionNeedsPassword function that tells the right thing for
  whether to prompt for a password, and improve
  PQconnectionUsedPassword so that it checks whether the password used
  by the connection was actually supplied as a connection argument,
  instead of coming from environment or a password file.  Per bug
  report from Mark Cave-Ayland and subsequent discussion.

- In pgsql/src/bin/psql/startup.c, fix bogus prompt for password in -u
  case.  Per gripe from Robert Treat.

- The E. J. Pratt verse used as a tsearch test case is unfortunately
  still under copyright in the US and many other places.  Substitute a
  little something from a poet who's more safely dead.  Per gripe from
  Bjorn Munch.

- Fix attribution for Rime of the Ancient Mariner (obviously it's been
  too long since freshman English :-()

== Abgelehnte Patches (bis jetzt) ==

xeb <AT> mail.ru's patch intended to convert binary integers
automatically in libpq on grounds of lack of design discussion and
incomplete type coverage.

== Eingesandte Patches ==

Andrew Chernow sent in another version of his pgparam patch.

Yoshiyuki Asaba sent in a patch to fix pgbench's time reporting for
the -C option.

Tom Lane sent in a patch to fix PQconnectionUsedPassword.

Andrew Dunstan sent in a patch to fix the buildenv.pl/buildenv.bat
issue on Windows.

-- 
		Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group: http://www.pgug.de
DPWN: http://ads.wars-nicht.de/blog/categories/18-PWN

pgsql-de-allgemein by date

Next:From: Olaf RadickeDate: 2007-12-16 23:44:21
Subject: DOSS attack
Previous:From: Andreas 'ads' ScherbaumDate: 2007-12-03 08:51:58
Subject: == Wöchentlicher PostgreSQL Newsletter - 02. Dezember 2007 ==

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