== WöchentlicherPostgreSQL Newsletter - 28.März2010

Der Originalartikel befindet sich unter:

http://www.postgresql.org/community/weeklynews/pwn20100328



== Wöchentlicher PostgreSQL Newsletter - 28. März 2010 ==

== PostgreSQL Produkt Neuigkeiten ==

dtester 0.1, ein ereignisgesteuertes Testwerkzeug, ist
erschienen. http://www.bluegap.ch/projects/dtester/

== PostgreSQL 9.0 Feature der Woche ==

Du kannst jetzt anonyme Code-Blöcke mittels DO in PL/pgsql, PL/Perl und
PL/LOLCODE nutzen.

== PostgreSQL Jobs im März ==

http://archives.postgresql.org/pgsql-jobs/2010-03/threads.ph p

== PostgreSQL Lokal ==

Die San Francisco PostgreSQL Usergruppe wird ein Testfest am Samstag dem
3. April von 11 Uhr bis 18 Uhr veranstalten. Es wird Live Videos geben.
Hilf mit, dies zu einem weltweiten Event zu machen!
http://wiki.postgresql.org/wiki/SFPUG_Beta_Test_Day

Linuxfest Nordwest 2010 findet in Bellingham, Washington, USA am
24. und 25. April statt. Vortragsreihen, Stände und Sponsoring
sind verfügbar.
http://linuxfestnorthwest.org/

Andreas (ads) Scherbaum hält einen Kurs "PostgreSQL im
Unternehmenseinsatz" an der VHS Magdeburg, Deutschland, vom 03. bis 07.
Mai 2010. Details unter:
http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Sch ulung-als-Bildu=
ngsurlaub-03.-07.05.2010-in-Magdeburg.html

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19.
http://www.pgcon.org/2010/registration.php

Der CfP für OSBridge ist eröffnet! OSBridge findet vom 1. bis 4.
Juni 2010 in Portland, Oregon statt.
http://opensourcebridge.org/events/2010/proposals/

OSCON wird in Portland, Oregon vom 19. bis 23. Juli 2010 stattfinden.
http://www.oscon.com/oscon2010

== PostgreSQL in den News ==

Planet PostgreSQL: http://planet.postgresql.org/

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@fetter.org, deutsche an
pwn@pgug.de, italienische an pwn@itpug.org.

== Angewandte Patches ==

Michael Meskes committed:

- In pgsql/src/interfaces/ecpg/test/preproc/strings.pgc, fixed ECPG
regression test to make sure it uses absolute paths for include
files instead of relative ones which break vpath builds.

Tom Lane committed:

- Fix an oversight in join-removal optimization: we have to check not
only for plain Vars that are generated in the inner rel and used
above the join, but also for PlaceHolderVars. Per report from Oleg
Kolyhalin.

- In pgsql/src/test/regress/output/constraints.source, fix regression
test breakage from recent change in default name of
exclusion-constraint index.

- In pgsql/src/backend/postmaster/pgstat.c, now that we know
last_statrequest > last_statwrite can be observed in the buildfarm,
expend a little more effort on the log message for it.

- In pgsql/src/backend/libpq/hba.c, fix thinko in log message for
"sameuser" ident map mismatch: the provided and authenticated
usernames were swapped. Reported by Bryan Henderson in bug #5386.
Also clean up poorly-maintained header comment for this function.

- In pgsql/contrib/intarray/_int_gin.c, fix ginint4_queryextract() to
actually do what it was intended to do for an unsatisfiable query,
such as indexcol && empty_array. It should return -1 to tell GIN no
scan is required; but silly typo disabled the logic for that,
resulting in unnecessary "GIN indexes do not support whole-index
scans" error. Per bug report from Jeff Trout. Back-patch to 8.3
where the logic was introduced.

Bruce Momjian committed:

- Re-order createuser and vacuumedb documentation options, for
consistency. Gabrielle Roth.

- In pgsql/doc/src/sgml/release-9.0.sgml, properly credit Simon Riggs
for functions pg_last_xlog_replay_location, etc.

- In pgsql/doc/src/sgml/release-9.0.sgml, add back other xlog()
function author names.

- In pgsql/doc/src/sgml/release-9.0.sgml, typo fix from Erik
(breinbaas) Rijkers.

- Document in postgresql.conf that the max_standby_delay default is 30
'seconds'.

Simon Riggs committed:

- In pgsql/src/backend/commands/indexcmds.c, shorten suffix of
automatically created indexes to "_excl" when using exclusion
constraints, in line with string length of other pre-9.0 suffixes.

- In pgsql/src/backend/replication/walsender.c, reduce CPU utilisation
of WALSender process. Process was using 10% CPU doing nothing,
caused by naptime specified in milliseconds yet units of pg_usleep()
parameter is microseconds. Correctly specifying units reduces call
frequency by 1000. Reduction in CPU consumption verified.

- In pgsql/src/backend/utils/init/postinit.c, change replication
connection log format to allow for a database called replication.
Add host and port details, following format of messages in
BackendInitialize().

- In pgsql/src/backend/replication/walsender.c, additional thoughts on
WALSender cpu reduction. Use long type and alter a comment to
reduce confusion.

- Modify some new and pre-existing messages for translatability.

- Derive latestRemovedXid for btree deletes by reading heap pages.
The WAL record for btree delete contains a list of tids, even when
backup blocks are present. We follow the tids to their heap tuples,
taking care to follow LP_REDIRECT tuples. We ignore LP_DEAD tuples
on the understanding that they will always have xmin/xmax earlier
than any LP_NORMAL tuples referred to by killed index tuples. Iff
all tuples are LP_DEAD we return InvalidTransactionId. The heap
relfilenode is added to the WAL record, requiring API changes to
pass down the heap Relation. XLOG_PAGE_MAGIC updated.

ITAGAKI Takahiro committed:

- Each worker thread will have its own log file in pgbench to avoid
interleaved writes. The first worker still uses "pgbench_log."
for the name, but additional workers use
"pgbench_log.." instead. Reported by Greg
Smith.

- Remove CRs for each line in pgbench.sgml.

- Clean up logging codes and add documentation. Add English
documentation. Split warm-standby and internal module
documentation. Change the default for
pg_statsinfo.syslog_line_prefix to 't %p '. Support non-default
log_error_verbosity. Support local, GMT and UTC for log_timezone,
but we cannot support others because postgres uses own timezone
implemntation. Simplify codes for log_line_prefix.

Peter Eisentraut committed:

- In pgsql/src/interfaces/ecpg/preproc/ecpg.addons, remove useless
double assignment GCC 4.5 complained about it.

Heikki Linnakangas committed:

- In pgsql/src/backend/replication/README, update description of
walrcv_receive() function to match reality.

- In pgsql/src/backend/replication/walsender.c, flush CopyOutResponse
when starting streaming in walsender, so that it's not delayed until
the first WAL record is sent. Fujii Masao.

Andrew Dunstan committed:

- In pgsql/src/Makefile.global.in, mark "installcheck-parallel",
"world", "install-world" and "installcheck-world" make targets as
PHONY. Fujii Masao.

Alvaro Herrera committed:

- Prevent ALTER USER f RESET ALL from removing the settings that were
put there by a superuser -- "ALTER USER f RESET setting" already
disallows removing such a setting. Apply the same treatment to
ALTER DATABASE d RESET ALL when run by a database owner that's not
superuser.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Devrim GUNDUZ sent in a patch to update the Turkish stop words in
tsearch2.

Fujii Masao sent in a doc patch for walreceiver per suggestion from
Hitoshi Harada.

Heikki Linnakangas sent a doc patch clarifying use of double-quoted
strings in pg_hba.conf. This became more relevant because of the
special replication database, as distinct from some database named
"replication" (with quotes).

Heikki Linnakangas and Fujii Masao sent in patches to try various ways
to get WALs when the database is in recovery mode.

Andrew Dunstan sent in a WIP patch to fix an xmlconcat bug.

Fujii Masao sent in another revision of the patch to fix the issue
where walreceiver is not interruptible on Windows.

Fujii Masao sent in a patch to fix a typo in a comment in
pgsql/src/backend/access/transam/xlog.c.

Tom Lane sent in a WIP patch to fix an issue with join removal.

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

--=20
Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-de-allgemein