== Wöchentlicher PostgreSQL Newsletter - 07. August 2011 ==

== Wöchentlicher PostgreSQL Newsletter - 07. August 2011 ==

am 08.08.2011 20:21:36 von adsmail

Der Originalartikel befindet sich unter:

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



== Wöchentlicher PostgreSQL Newsletter - 07. August 2011 ==

Consitent State und die US PostgreSQL Association veranstalten einen
Trainingstag am 21. Oktober 2011.
http://pgday.consistentstate.com/node/15

PostgreSQL Conference Europe 2011 findet vom 18. bis 21. Oktober
im Casa 400 Hotel in Amsterdam, Niederlande statt. Es werden
Vorträge für PostgreSQL Anwender, Entwickler und Beitragende
dabei sein, sowie für Entscheidungsträger. Für mehr Informat=
ionen
über die Konferenz bitte die Webseite besuchen:
http://2011.pgconf.eu/

== PostgreSQL Lokal ==

PGDay Porto Alegre findet am 19. August 19 2011
in Porto Alegre, RS, Brasilien statt.
http://www.postgresql.org.br/eventos/2011/pgday/rs

Postgres Open 2011, eine Konferenz die sich auf den Umbruch der
Datenbankindustrie durch PostgreSQL konzentriert, wird vom 14. bis 16.
September 2011 in Chicago, Illinois im Westin Michigan Avenue
Hotel stattfinden.
http://postgresopen.org

PG-Day Denver 2011 findet am Freitag, dem 21. Oktober 2011 auf dem
Auraria Campus in der Nähe von Downtown Denver, Colorado statt.
http://pgday.consistentstate.com/

PostgreSQL Conference West (#PgWest) findet vom 27. bis 30. September
2011 im San Jose Convention Center in Jan Jose, Kalifornen, USA statt.
http://www.postgresqlconference.org

PostgreSQL Conference Europe 2011 findet vom 18. bis
21. Oktober in Amsterdam statt.
http://2011.pgconf.eu/

pgbr findet in Sao Paulo, Brazilien, am 3. und 4. November 2011 statt.
http://pgbr.postgresql.org.br/

PGConf.DE 2011 ist die Deutschsprachige PostgreSQL Konferenz
und wird am 11. November 2011 im Rheinischen Industriemuseum
in Oberhausen, Deutschland, stattfinden. Der Call for Papers ist offen.
http://2011.pgconf.de/

== PostgreSQL in den News ==

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

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fet=
ter.

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, spanische an pwn@arpug.com.ar.

== Reviews ==

== Angewandte Patches ==

Robert Haas pushed:

- Minor stylistic corrections.
=20
http://git.postgresql.org/pg/commitdiff/85b436f7b1f06a6ffa8d 2f29b03d6e440de=
18784

- Make pgbench use erand48() rather than random(). glibc renders
random() thread-safe by wrapping a futex lock around it; testing
reveals that this limits the performance of pgbench on machines with
many CPU cores. Rather than switching to random_r(), which is only
available on GNU systems and crashes unless you use undocumented
alchemy to initialize the random state properly, switch to our
built-in implementation of erand48(), which is both thread-safe and
concurrent. Since the list of reasons not to use the operating
system's erand48() is getting rather long, rename ours to
pg_erand48() (and similarly for our implementations of lrand48() and
srand48()) and just always use those. We were already doing this on
Cygwin anyway, and the glibc implementation is not quite
thread-safe, so pgbench wouldn't be able to use that either. Per
discussion with Tom Lane.
=20
http://git.postgresql.org/pg/commitdiff/4af43ee3f165c8e4b332 a7e680a44f4b7ba=
2d3c1

- Teach psql to display comments on languages and casts. The output
of \dL (list languages) is fairly narrow, so we just always display
the comment. \dC (list casts) can get fairly wide, so we only
display comments if the new \dC+ option is specified. Josh
Kupershmidt.
=20
http://git.postgresql.org/pg/commitdiff/3b17efdfdd846c9bfad1 637686e6f18198e=
a3df5

- Create VXID locks "lazily" in the main lock table. Instead of
entering them on transaction startup, we materialize them only when
someone wants to wait, which will occur only during CREATE INDEX
CONCURRENTLY. In Hot Standby mode, the startup process must also be
able to probe for conflicting VXID locks, but the lock need never be
fully materialized, because the startup process does not use the
normal lock wait mechanism. Since most VXID locks never need to
touch the lock manager partition locks, this can significantly
reduce blocking contention on read-heavy workloads. Patch by me.
Review by Jeff Davis.
=20
http://git.postgresql.org/pg/commitdiff/84e37126770dd6de903d ad88ce150a49b63=
b5ef9

- Tweak PQresStatus() to avoid a clang compiler warning. The previous
test for status < 0 test is in fact testing nothing if the compiler
considers an enum to be an unsigned data type. clang doesn't like
tautologies, so do this instead. Report by Peter Geoghegan, fix as
suggested by Tom Lane.
=20
http://git.postgresql.org/pg/commitdiff/b43bf617fdb3ecde7098 92c3bd8997ac414=
10f2f

- Modestly improve pgbench's checking for invalid ranges. The old
check against MAX_RANDOM_VALUE is clearly irrelevant since getrand()
no longer calls random(). Instead, check whether min and max are
close enough together to avoid an overflow inside getrand(), as
suggested by Tom Lane. This is still somewhat silly, because we're
using atoi(), which doesn't check for overflow anyway and (at least
on my system) will cheerfully return 0 when given "4294967296". But
that's a problem for another commit.
=20
http://git.postgresql.org/pg/commitdiff/68cbb9f4e70b7b7ed515 b5c63bafbe47d96=
17bf0

- Allow per-column foreign data wrapper options. Shigeru Hanada, with
fairly minor editing by me.
=20
http://git.postgresql.org/pg/commitdiff/c4096c76399ad99dce35 cd62f60599ea874=
8a3dd

Heikki Linnakangas pushed:

- Avoid integer overflow when LIMIT + OFFSET >=3D 2^63. This fixes bug
#6139 reported by Hitoshi Harada.
=20
http://git.postgresql.org/pg/commitdiff/89df948ec26679e09f71 baf6bbb9b06f9d3=
29712

Tom Lane pushed:

- Fix incorrect initialization of ProcGlobal->startupBufferPinWaitBufId.
It was initialized in the wrong place and to the wrong value. With
bad luck this could result in incorrect query-cancellation failures
in hot standby sessions, should a HS backend be holding pin on
buffer number 1 while trying to acquire a lock.
=20
http://git.postgresql.org/pg/commitdiff/2e53bd5517431637e495 c7614761e5aae46=
b4eba

- Move CheckRecoveryConflictDeadlock() call to a safer place. This
kluge was inserted in a spot apparently chosen at random: the lock
manager's state is not yet fully set up for the wait, and in
particular LockWaitCancel hasn't been armed by setting lockAwaited,
so the ProcLock will not get cleaned up if the ereport is thrown.
This seems to not cause any observable problem in trivial test
cases, because LockReleaseAll will silently clean up the debris; but
I was able to cause failures with tests involving subtransactions.
Fixes breakage induced by commit=20
c85c941470efc44494fd7a5f426ee85fc65c268c.
Back-patch to all affected branches.
=20
http://git.postgresql.org/pg/commitdiff/ac36e6f71f197540b8ee 83c97f338ae5e51=
63f30

- Reduce PG_SYSLOG_LIMIT to 900 bytes. The previous limit of 1024 was
set on the assumption that all modern syslog implementations have
line length limits of 2KB or so. However, this is false, as at
least Solaris and sysklogd truncate at only 1KB. 900 seems to leave
enough room for the max likely length of the tacked-on prefixes, so
let's go with that. As with the previous change, it doesn't seem
wise to back-patch this into already-released branches; but it
should be OK to sneak it into 9.1. Noah Misch
=20
http://git.postgresql.org/pg/commitdiff/375aa7b393843800a2bf efcbc13fa68ca82=
dee53

- Fix thinko in documentation of local_preload_libraries. Somebody
added a cross-reference to shared_preload_libraries, but wrote the
wrong variable name when they did it (and didn't bother to make it a
link either). Spotted by Christoph Anton Mitterer.
=20
http://git.postgresql.org/pg/commitdiff/ffcf5a6c41ce91c55991 b04eea1fcb94e4d=
0faa0

- Clean up ill-advised attempt to invent a private set of Node tags.
Somebody thought it'd be cute to invent a set of Node tag numbers
that were defined independently of, and indeed conflicting with, the
main tag-number list. While this accidentally failed to fail so
far, it would certainly lead to trouble as soon as anyone wanted to,
say, apply copyObject to these node types. Clang was already
complaining about the use of makeNode on these tags, and I think
quite rightly so. Fix by pushing these node definitions into the
mainstream, including putting replnodes.h where it belongs.
=20
http://git.postgresql.org/pg/commitdiff/05e83968929f4ec1eba0 58fcae755fd2df9=
8864e

Bruce Momjian pushed:

- In documentaiton, clarify which commands have reduced WAL volume for
wal_level =3D minimum. Backpatch to 9.1 and 9.0.
=20
http://git.postgresql.org/pg/commitdiff/38de5aad54b3eb37981c acd391fcde82f86=
d00fb

- Fix markup for recent wal_level clarification. Backpatch to 9.1 and 9.0.
=20
http://git.postgresql.org/pg/commitdiff/4262e61d6424a38150f1 25b612fd9002677=
18148

Andrew Dunstan pushed:

- Restore the primacy of postgres.h in plpython.c. To avoid having
the python headers hijack various definitions, we now include them
after all the system headers we want, having first undefined some of
the things they want to define. After that's done we restore the
things they scribbled on that matter, namely our snprintf and
vsnprintf macros, if we're using them.
=20
http://git.postgresql.org/pg/commitdiff/a11cf4334138c3af8504 c71a091b4f5c317=
776ef

Peter Eisentraut pushed:

- Fix a whitespace issue with the man pages There is what may actually
be a mistake in our markup. The problem is in a situation like

FOO is ...
there is strictly speaking a line break before "FOO". In the HTML
output, this does not appear to be a problem, but in the man page
output, this shows up, so you get double blank lines at odd places.
So far, we have attempted to work around this with an XSL hack, but
that causes other problems, such as creating run-ins in places like
SQL COPY So fix the problem
properly by removing the extra whitespace. I only fixed the
problems that affect the man page output, not all the places.
=20
http://git.postgresql.org/pg/commitdiff/6ef24487967692604b07 a4a54e71821a60f=
b729a

- Rename "Example" sections to "Examples" in dblink chapter. For
consistency with other man pages.
=20
http://git.postgresql.org/pg/commitdiff/a559ed5ed611f7937cc8 7d4fd420a63ab2a=
27356

- Remove whitespace from end of lines
=20
http://git.postgresql.org/pg/commitdiff/f29a004496b3378f98b2 4c088cd846877ea=
cf582

- Add "Compatibility" section to ALTER EXTENSION reference page Almost
all other pages have one; this one must have been forgotten.
=20
http://git.postgresql.org/pg/commitdiff/04b17684af24791b18e4 14e304fb6d9b57a=
36c5e

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Heikki Linnakangas sent in two revisions of a patch to fix some issues
with GiST's interaction with Hot Standby.

Dean Rasheed sent in two revisions of a patch to trim the memory AFTER
triggers use.

Timothy D. F. Lewis and Josh Kupershmidt traded revisions of the patch
to help with vacuuming large objects.

Kevin Grittner sent in another patch intended to fix bug #6123.

Alexander Korotkov sent in three revisions of a patch to speed up GiST
index builds.

Alvaro Herrera sent in two more revisions of a patch to catalogue NOT
NULL constraints.

Phil Sorber sent in patches to correct some infelicities in
pg_dumpall's handling of ROLEs.

Tom Lane sent in two revisions of a patch intended to fix a data
corruption issue reported by David Gould on large (32-core, 512G main
memory), highly-loaded systems.

Robert Haas and Josh Kupershmidt traded patches to further refine the
display of object comments in psql.

Zoltan Boszormenyi sent in another revision of a patch to create and
use cross-column stastics.

Peter Geoghegan sent in two more patches to clean up some infelicities
exposed by the Clang compiler.

Jeff Janes sent in a patch to fix a speed issue with larger numbers of
cores first uncovered by mosbench.

Jun Ishiduka sent in another revision of the patch to allow doing a
base backup from a Hot Standby.

Alex Hunsaker sent in a patch to fix some infelicities in PL/Perl(U)'s
signal handling.

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