== Wöchentlicher PostgreSQL Newsletter - 08. Mai 2011 ==
am 09.05.2011 07:59:16 von adsmailDer Originalartikel befindet sich unter:
http://www.postgresql.org/community/weeklynews/pwn20110508
== Wöchentlicher PostgreSQL Newsletter - 08. Mai 2011 ==
PostgreSQL 9.1 Beta 1 ist erschienen. Testen!
http://www.postgresql.org/developer/beta
AustinPUG trifft sich am 11. Mai um 19:00 Uhr in Austin, Texas, USA.
Kostenlose Pizza! Um Essen zu erhalten, bitte unter
http://pugs.postgresql.org/austinpug
CHAR(11), die PostgreSQL Konferenz für Clustering, Hochverfügbark=
eit
und Replikation hat jetzt die Registrierung eröffnet.
Die Konferenz findet am 11. und 12. Juli 2011 in Cambridge, UK statt.
http://www.char11.org/
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 Produkt Neuigkeiten ==
pgbuildfarm Client 4.5 ist erschienen.
http://pgfoundry.org/forum/forum.php?forum_id=3D1833
pgpool-II 3.1.0 Alpha2, ein Connection Pooler und mehr, ist erschienen.
http://pgfoundry.org/projects/pgpool/
== PostgreSQL Jobs im Mai ==
http://archives.postgresql.org/pgsql-jobs/2011-05/threads.ph p
== PostgreSQL Lokal ==
PGCon findet am 19. und 20. Mai 2011 an der Universität
von Ottawa statt, vorher gibt es am 17. und 18. Mai
zwei Tage mit Trainings.
http://www.pgcon.org/2011/
PG Session 2 über PostGIS findet am 23. Juni in Paris statt.
Der Call for Papers ist jetzt offen.
http://www.postgresql-sessions.org/en/2/
PostgreSQL Conference Europe 2011 will be held on October 18-21 in
Amsterdam.
http://2011.pgconf.eu/
pgbr findet in Sao Paulo, Brazilien, am 3. und 4. November 2011 statt.
http://pgbr.postgresql.org.br/
== 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 ==
Tom Lane pushed:
- Improve aset.c's space management in contexts with small
maxBlockSize. The previous coding would allow requests up to half
of maxBlockSize to be treated as "chunks", but when that actually
did happen, we'd waste nearly half of the space in the malloc block
containing the chunk, if no smaller requests came along to fill it.
Avoid this scenario by limiting the maximum size of a chunk to 1/8th
maxBlockSize, so that we can waste no more than 1/8th of the
allocated space. This will not change the behavior at all for the
default context size parameters (with large maxBlockSize), but it
will change the behavior when using ALLOCSET_SMALL_MAXSIZE. In
particular, there's no longer a need for spell.c to be overly
concerned about the request size parameters it uses, so remove a
rather unhelpful comment about that. Merlin Moncure, per an idea of
Tom Lane's
=20
http://git.postgresql.org/pg/commitdiff/6755558b92748287e961 fed518c14be3756=
30464
- Fix pull_up_sublinks' failure to handle nested pull-up
opportunities. After finding an EXISTS or ANY sub-select that can
be converted to a semi-join or anti-join, we should recurse into the
body of the sub-select. This allows cases such as
EXISTS-within-EXISTS to be optimized properly. The original coding
would leave the lower sub-select as a SubLink, which is no better
and often worse than what we can do with a join. Per example from
Wayne Conrad. Back-patch to 8.4. There is a related issue in older
versions' handling of pull_up_IN_clauses, but they're lame enough
anyway about the whole area that it seems not worth the extra work
to try to fix.
=20
http://git.postgresql.org/pg/commitdiff/dcc685debb02c507b88a a8052f9e6334a7c=
3f830
- Include unary plus in the Operator Precedence table. Per gripe from
Grzegorz Szpetkowski. Also, change the subsection heading from
"Lexical Precedence" (which is a contradiction in terms) to
"Operator Precedence".
=20
http://git.postgresql.org/pg/commitdiff/671322751add80f3368c d9ef17134fb9f73=
cf747
- Remove precedence labeling of keywords TRUE, FALSE, UNKNOWN, and
ZONE. These were labeled with precedences just to avoid attaching
explicit precedences to the productions in which they were the last
terminal symbol. Since a terminal symbol precedence marking can
affect many other things too, it seems like better practice to
attach precedence labels to the productions, and not mark the
terminal symbols. Ideally we'd also remove the precedence attached
to NULL_P, but it turns out that we are actually depending on that
having a precedence higher than POSTFIXOP, else we get a
shift/reduce conflict for postfix operators in b_expr. (Which more
or less proves my point about these markings having a high risk of
unexpected consequences.) For the moment, move NULL_P into the set
of keywords grouped with IDENT, so that at least it will act
similarly to non-keywords; and document the interaction.
=20
http://git.postgresql.org/pg/commitdiff/12b7164578e73abb065a 835c588c1e0c446=
70ed3
- Move RegisterPredicateLockingXid() call to a safer place. The SSI
patch inserted a call of RegisterPredicateLockingXid into
GetNewTransactionId, which was a bad idea on a couple of grounds.
First, it's not necessary to hold XidGenLock while manipulating that
shared memory, and doing so is bad because XidGenLock is a
high-contention lock that should be held for as short a time as
possible. (Not to mention that it adds an entirely unnecessary
deadlock hazard, since we must take SerializableXactHashLock as
well.) Second, the specific place where it was put was between
extending CLOG and advancing nextXid, which could result in
unpleasant behavior in case of a failure there. Pull the call out
to AssignTransactionId, which is much safer and arguably better from
a modularity standpoint too. There is more work to do to clean up
the failure-before-advancing-nextXid issue, but that is a separate
change that will need to be back-patched. So for the moment I just
want to make GetNewTransactionId look the same as it did in prior
versions.
=20
http://git.postgresql.org/pg/commitdiff/d2088ae949993ad8e3aa bc3b6a9cd77aa5c=
ac957
- Fix some portability issues in isolation regression test driver.
Remove random system #includes in favor of using postgres_fe.h.
(The alternative to that is letting this module grow its own
configuration testing ability...) Also fix the "make clean" target
to actually clean things up. Per local testing.
=20
http://git.postgresql.org/pg/commitdiff/eff223ffd74eed268f35 d693462969f7f75=
632d2
Peter Eisentraut pushed:
- Small cleanup of spacing in verbatim DocBook elements
=20
http://git.postgresql.org/pg/commitdiff/4b08bf8ce7a7515f669c e0a1ce1946c6492=
b65ed
- Fix alignment of --help output. Tabs replaced by spaces.
=20
http://git.postgresql.org/pg/commitdiff/ce2fc20071a6ae68e63b d675b147818669c=
d83b4
- Message style cleanup
=20
http://git.postgresql.org/pg/commitdiff/bff074b1ab0dfed7a782 2dcc8942f877efa=
3b914
- Remove redundant port number check. pg_basebackup doesn't need to
police the format of port numbers. libpq already does that.
=20
http://git.postgresql.org/pg/commitdiff/7f1f1bfdbb199a003b9b ef5dc946eb2c1c3=
8e4c2
- Link some tables into the surrounding text by their id
=20
http://git.postgresql.org/pg/commitdiff/a3b681f0bc46de6ae89c 7e17c1704329ffc=
3ba76
- Improve pg_archivecleanup and pg_standby --help output. For
consistency with other tools, put the options before further usage
information. In pg_standby, remove the supposedly deprecated -l
option from the given example invocation.
=20
http://git.postgresql.org/pg/commitdiff/b24181b26fc90758370e 475088be4ef2497=
d3cc3
- Improve formatting of pg_upgrade --help output.
=20
http://git.postgresql.org/pg/commitdiff/d6d823c8b0e6878cf532 120c0c019c7704b=
27be3
- Improve compiler string shown in version(). With some compilers
such as Clang and ICC emulating GCC, using a version string of the
form "GCC $version" can be quite misleading. Also, a great while
ago, the version output from gcc --version started including the
string "gcc", so it is redundant to repeat that. In order to
support ancient GCC versions, we now prefix the result with "GCC "
only if the version output does not start with a letter.
=20
http://git.postgresql.org/pg/commitdiff/8dd2ede3f82505c3fd04 1c1953524305df0=
732d1
Alvaro Herrera pushed:
- Update some ALTER USER cross-references to ALTER ROLE. Greg Smith
=20
http://git.postgresql.org/pg/commitdiff/52897e54db1000f2fa45 b31e02eb252dd05=
73516
- Add ID attribute to some sect2's missing it. David Fetter
=20
http://git.postgresql.org/pg/commitdiff/155743ad3108cd586d56 e864d1209b82f9a=
716f0
- Update obsolete mention of Sequoia, now known as Tungsten. Per
http://joomla.aws.continuent.com/community/lab-projects/sequ oia Greg
Smith
=20
http://git.postgresql.org/pg/commitdiff/04be7ac271c4b6db6ba5 18225f58f936b3b=
4435c
- Improve description of read/write traffic scalability. Greg Smith,
after a suggestion of James Bruce
=20
http://git.postgresql.org/pg/commitdiff/561485709673f4bc0524 0e891dd9056bded=
bbcbc
Bruce Momjian pushed:
- Improve style of generate_history.pl Perl script.
=20
http://git.postgresql.org/pg/commitdiff/fb3ad7895ece674fc529 8df754253f70cda=
6a02e
- Adjust pg_upgrade FATAL error messages to have consistent newlines.
Also adjust some error message capitalization for consistency.
=20
http://git.postgresql.org/pg/commitdiff/5c5f83507cb697e436f8 f9d20d62787c1a6=
6d19c
- Check that the pg_upgrade user specified is a super-user. Also
report the error message when the post-pg_ctl connection fails. Per
private bug report from EnterpriseDB.
=20
http://git.postgresql.org/pg/commitdiff/81301b85781245676f87 4ae3908015f05d3=
aaaa2
- In pg_upgrade, report non-super-user username in error message.
=20
http://git.postgresql.org/pg/commitdiff/1609ca5adb5c8b550764 35094532dfbb2a2=
aea43
- Add missing documention connecting word.
=20
http://git.postgresql.org/pg/commitdiff/5293de580734bb16c57d e51142354d76347=
a3336
- Add xreflabels to /contrib manuals so links appear correct. Also
update README.links to explain xref properly.
=20
http://git.postgresql.org/pg/commitdiff/e567c9ff3409203a3ab5 0a2ff87cdab73be=
f6313
- Add C comment why client encoding can be set in pg_upgrade.
=20
http://git.postgresql.org/pg/commitdiff/e6a740284291d1ebaca4 2b2954eb20e09da=
ac9b9
- Add C comment about the fact that the autovacuum limit can go
backwards by 3, but that is it OK.
=20
http://git.postgresql.org/pg/commitdiff/76e5b4c85d5d48308880 44fc885b1da0d78=
1aed0
Magnus Hagander pushed:
- Clarify error message when attempting to create index on foreign
table. Instead of just saying "is not a table", specifically state
that indexes aren't supported on *foreign* tables.
=20
http://git.postgresql.org/pg/commitdiff/d76a149c955a6525c8d4 2425c57e32d74d2=
c2eed
- Unbreak the regression tests from my previous commit
=20
http://git.postgresql.org/pg/commitdiff/27525b183189487c674f 24620e608298ac0=
c8e29
Robert Haas pushed:
- Fix typos in SECURITY LABEL documentation. KaiGai Kohei
=20
http://git.postgresql.org/pg/commitdiff/3ef5b2df9738fd0795c1 ffcaada93c3c5df=
7cd49
- Add comment about memory reordering to PredicateLockTupleRowVersionLink.
Dan Ports, per head-scratching from Simon Riggs and myself.
=20
http://git.postgresql.org/pg/commitdiff/71932ecc2b6ca0d74817 6a7e8b11d3575bf=
4caf3
== Abgelehnte Patches (bis jetzt) ==
No one was disappointed this week :-)
== Eingesandte Patches ==
Gabriele Bartolini sent in another revision of the patch to smooth
replication during VACUUM FULL.
Joe Conway sent in a patch to fix clog redos under high load.
Johann 'Myrkraverk' Oskarsson sent in a patch to fix an issue on
mingw-w64 where the PGDLLEXPORT macro is blank.
Alvaro Herrera updated the "preferred types" patch to HEAD.
Jaime Casanova sent in a patch to add an xlogversion column to
IDENTIFY_SYSTEM. This is one of the infrastructure pieces which will
make on-line upgrades possible.
Hitoshi Harada sent in a patch to allow the optimizer to pull up
aggregate subqueries.
Bruce Momjian sent in patches to adjust the comments on system tables.
Magnus Hagander sent in a patch to fix the error for attempting to
index a foreign table.
Tom Lane sent in a patch to fix a some suprising precedence in
PostgreSQL's SQL grammar.
Dan Ports sent in two revisions of a patch to fix a race condition in
SSI's ChecTargetForConflictsIn.
Peter Geoghegan sent in a WIP patch to help save energy by waking up
less frequently.
Merlin Moncure sent in another revision of the patch to fix an issue
between the visibility map and hint bits.
Robert Haas sent in another revision of the patch to make visibility
maps more crash-safe.
Josh Kupershmidt sent in a patch to clean up psql's decribe.c.
Andrew Dunstan sent in another revision of the patch to fix an issue
where invalid characters were allowed in XML.
Greg Smith sent in a patch exemplifying the idea of moving some
contrib modules to being default, but still using the EXTENSION
infrastructure.
--
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