== Wöchentlicher PostgreSQL Newsletter - 27. März 2011 ==

== Wöchentlicher PostgreSQL Newsletter - 27. März 2011 ==

am 30.03.2011 00:31:56 von adsmail

Der Originalartikel befindet sich unter:


== Wöchentlicher PostgreSQL Newsletter - 27. März 2011 ==

Greg Smith veröffentlichte eine Revision des Performance Farm Codes,
basierend auf Andrew Dunstans Buildfarm Code.

pgbr findet in Sao Paulo, Brazilien, am 3. und 4. November 2011 statt.

PG Session 2 über PostGIS findet am 23. Juni in Paris statt.
Der Call for Papers ist jetzt offen.

== PostgreSQL Produkt Neuigkeiten ==

Dumbo 0.50, ein Terminal Client für PostgreSQL, ist erschinenen.

MyJSQLView 3.26, ein GUI Werkzeug welches mit PostgreSQL verwendet
werden kann, ist erschienen.
http://dandymadeproductions.com/projects/MyJSQLView/index.ht ml

Npgsql 2.0.12beta1, ein .NET Treiber für PostgreSQL, ist erschienen.

== PostgreSQL Jobs im März ==

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

== PostgreSQL Lokal ==

Es wird eine umfangreiche PostgreSQL Präsenz auf der MySQL Konferenz
und Expo am am 11-14. April 2011 in Santa Clara, Kalifornien, geben.
http://en.oreilly.com/mysql2011/public/schedule/tag/postgres ql

Das Open Database Camp findet vom 7. bis 9. Mai 2011 in Sardinien,
Italien statt.
http://datacharmer.blogspot.com/2011/01/announcing-open-data base-camp-sardi=

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.

== PostgreSQL in den News ==

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

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

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

Heikki Linnakangas pushed:

- When two base backups are started at the same time with
pg_basebackup, ensure that they use different checkpoints as the
starting point. We use the checkpoint redo location as a unique
identifier for the base backup in the end-of-backup record, and in
the backup history file name. Bug spotted by Fujii Masao.
http://git.postgresql.org/pg/commitdiff/6d8096e2f3f2c1296fa8 80f44f3fa5701b2=

Tom Lane pushed:

- Fix check_exclusion_constraint() to insert correct collations in
http://git.postgresql.org/pg/commitdiff/d0dd5c73527d4adc1121 1bd6ad43e3be121=

- Reimplement planner's handling of MIN/MAX aggregate optimization
(again). Instead of playing cute games with pathkeys, just build a
direct representation of the intended sub-select, and feed it
through query_planner to get a Path for the index access. This is a
bit slower than 9.1's previous method, since we'll duplicate most of
the overhead of query_planner; but since the whole optimization only
applies to rather simple single-table queries, that probably won't
be much of a problem in practice. The advantage is that we get to
do the right thing when there's a partial index that needs the
implicit IS NOT NULL clause to be usable. Also, although this makes
planagg.c be a bit more closely tied to the ordering of operations
in grouping_planner, we can get rid of some coupling to lower-level
parts of the planner. Per complaint from Marti Raudsepp.
http://git.postgresql.org/pg/commitdiff/8df08c84894001d3d3f5 d10b3290a1063a4=

- Avoid potential deadlock in InitCatCachePhase2(). Opening a
catcache's index could require reading from that cache's own
catalog, which of course would acquire AccessShareLock on the
catalog. So the original coding here risks locking index before
heap, which could deadlock against another backend trying to get
exclusive locks in the normal order. Because InitCatCachePhase2 is
only called when a backend has to start up without a relcache init
file, the deadlock was seldom seen in the field. (And by the same
token, there's no need to worry about any performance disadvantage;
so not much point in trying to distinguish exactly which catalogs
have the risk.) Bug report, diagnosis, and patch by Nikhil Sontakke.
Additional commentary by me. Back-patch to all supported branches.
http://git.postgresql.org/pg/commitdiff/1192ba8b67df1446973c 71aafde5f6f613d=

- Throw error for indeterminate collation of an ORDER/GROUP/DISTINCT
target. This restores a parse error that was thrown (though only in
the ORDER BY case) by the original collation patch. I had removed
it in my recent revisions because it was thrown at a place where
collations now haven't been computed yet; but I thought of another
way to handle it. Throwing the error at parse time, rather than
leaving it to be done at runtime, is good because a syntax error
pointer is helpful for localizing the problem. We can reasonably
assume that the comparison function for a collatable datatype will
complain if it doesn't have a collation to use. Now the planner
might choose to implement GROUP or DISTINCT via hashing, in which
case no runtime error would actually occur, but it seems better to
throw error consistently rather than let the error depend on what
the planner chooses to do. Another possible objection is that the
user might specify a nondefault sort operator that doesn't care
about collation ... but that's surely an uncommon usage, and it
wouldn't hurt him to throw in a COLLATE clause anyway. This change
also makes the ORDER BY/GROUP BY/DISTINCT case more consistent with
the UNION/INTERSECT/EXCEPT case, which was already coded to throw
this error even though the same objections could be raised there.
http://git.postgresql.org/pg/commitdiff/37d6d07dda28a5dffcad 6ff195ab2c83aae=

- Improve reporting of run-time-detected indeterminate-collation
errors. pg_newlocale_from_collation does not have enough context to
give an error message that's even a little bit useful, so move the
responsibility for complaining up to its callers. Also, reword
ERRCODE_INDETERMINATE_COLLATION error messages in a less jargony,
more message-style-guide-compliant fashion.
http://git.postgresql.org/pg/commitdiff/6e197cb2e537880f3682 8a6c55d0f6df5bf=

- Make initdb ignore locales for client-only encodings. While putting
such entries into pg_collation is harmless (since backends will
ignore entries that don't match the database encoding), it's also
http://git.postgresql.org/pg/commitdiff/5d1d679dbf7806946735 29bd864ca1e258a=

- Fix ancient typo in user-defined-aggregates documentation. The
description of the initcond value for the built-in avg(float8)
aggregate has been wrong since it was written. Noted by Disc
http://git.postgresql.org/pg/commitdiff/ba7d020d9d6edba87217 3f8640ca240e00a=

- Improve user-defined-aggregates documentation. On closer
inspection, that two-element initcond value seems to have been a
little white lie to avoid explaining the full behavior of
float8_accum. But if people are going to expect the examples to be
exactly correct, I suppose we'd better explain. Per comment from
Thom Brown.
http://git.postgresql.org/pg/commitdiff/472671e133da77f280e8 7cb47c6544c7557=

- Clean up handling of COLLATE clauses in index column definitions.
Ensure that COLLATE at the top level of an index expression is
treated the same as a grammatically separate COLLATE. Fix bogus
reverse-parsing logic in pg_get_indexdef.
http://git.postgresql.org/pg/commitdiff/3bba9ce945a702ab116f cedb9c0b970ecd6=

- Fix handling of collation in SQL-language functions. Ensure that
parameter symbols receive collation from the function's resolved
input collation, and fix inlining to behave properly. BTW, this
commit lays about 90% of the infrastructure needed to support use of
argument names in SQL functions. Parsing of parameters is now done
via the parser-hook infrastructure ... we'd just need to supply a
column-ref hook ...
http://git.postgresql.org/pg/commitdiff/27dc7e240bfd230ee131 5cc00577a6ed72a=

- Fix collation handling in plpgsql functions. Make plpgsql treat the
input collation as a polymorphism variable, so that we cache
separate plans for each input collation that's used in a particular
session, as per recent discussion. Propagate the input collation to
all collatable input parameters. I chose to also propagate the
input collation to all declared variables of collatable types, which
is a bit more debatable but seems to be necessary for
non-astonishing behavior. (Copying a parameter into a separate
local variable shouldn't result in a change of behavior, for
example.) There is enough infrastructure here to support declaring a
collation for each local variable to override that default, but I
thought we should wait to see what the field demand is before adding
such a feature. In passing, remove exec_get_rec_fieldtype(), which
wasn't used anywhere. Documentation patch to follow.
http://git.postgresql.org/pg/commitdiff/a4425e3200f2c2578bdf 94bb62341691157=

- Document collation handling in SQL and plpgsql functions. This is
pretty minimal but covers the bare facts.
http://git.postgresql.org/pg/commitdiff/9b19c12e1d930a237817 dd432100388990e=

- Fix failure to propagate collation in negate_clause(). Turns out it
was this, and not so much plpgsql, that was at fault in Stefan
Huehner's collation-error-in-a-trigger bug report of a couple weeks
http://git.postgresql.org/pg/commitdiff/c8e993503d0f1a0cb8f1 87a136fb64cead9=

- Pass collation to makeConst() instead of looking it up internally.
In nearly all cases, the caller already knows the correct collation,
and in a number of places, the value the caller has handy is more
correct than the default for the type would be. (In particular,
this patch makes it significantly less likely that
eval_const_expressions will result in changing the exposed collation
of an expression.) So an internal lookup is both expensive and
http://git.postgresql.org/pg/commitdiff/bfa4440ca5d948c4d4f0 ab5bb82d433200c=

- Clean up a few failures to set collation fields in expression nodes.
I'm not sure these have any non-cosmetic implications, but I'm not
sure they don't, either. In particular, ensure the CaseTestExpr
generated by transformAssignmentIndirection to represent the base
target column carries the correct collation, because parse_collate.c
won't fix that. Tweak lsyscache.c API so that we can get the
appropriate collation without an extra syscache lookup.
http://git.postgresql.org/pg/commitdiff/b23c9fa9293c54a38290 93d207be37a7b42=

- More collations cleanup, from trawling for missed collation
assignments. Mostly cosmetic, though I did find that
generateClonedIndexStmt failed to clone the index's collations.
http://git.postgresql.org/pg/commitdiff/0c9d9e8dd655fff7bcfc 401e82838b8c20c=

- Clean up cruft around collation initialization for tupdescs and
scankeys. I found actual bugs in GiST and plpgsql; the rest of this
is cosmetic but meant to decrease the odds of future bugs of
http://git.postgresql.org/pg/commitdiff/7208fae18f1fdb242b4f cced77a3b836e15=

- Fix plpgsql to release SPI plans when a function or DO block is
freed. This fixes the gripe I made a few months ago about DO blocks
getting slower with repeated use. At least, it fixes it for the
case where the DO block isn't aborted by an error. We could try
running plpgsql_free_function_memory() even during error exit, but
that seems a bit scary since it makes a lot of presumptions about
the data structures being in good shape. It's probably reasonable
to assume that repeated failures of DO blocks isn't a
performance-critical case.
http://git.postgresql.org/pg/commitdiff/87f2ad1326bff5cd37dd e6fbf024137a224=

Simon Riggs pushed:

- Update docs to say you need fsync to make sync rep work fast.
http://git.postgresql.org/pg/commitdiff/6e8e7cc580665ddd43c8 ca2acc6d60f3455=

- Make FKs valid at creation when added as column constraints. Bug
report from Alvaro Herrera.
http://git.postgresql.org/pg/commitdiff/ec497a5ad6a0849efa3f b2fd05988bd8e0c=

- Prevent intermittent hang in recovery from bgwriter interaction.
Startup process waited for cleanup lock but when hot_standby =3D off
the pid was not registered, so that the bgwriter would not wake the
waiting process as intended.
http://git.postgresql.org/pg/commitdiff/b98ac467f5d35970edad e4ad65c767fc890=

- Minor changes to recovery pause behaviour. Change location LOG
message so it works each time we pause, not just for final pause.
Ensure that we pause only if we are in Hot Standby and can connect
to allow us to run resume function. This change supercedes the code
to override parameter recoveryPauseAtTarget to false if not
attempting to enter Hot Standby, which is now removed.
http://git.postgresql.org/pg/commitdiff/b5f2f2a712e56fe1edf7 d5665c07ee97be4=

- Additional test for each commit in sync rep path to plug minute
possibility of race condition that would effect performance only.
Requested by Robert Haas. Re-arrange related comments.
http://git.postgresql.org/pg/commitdiff/92f4786fa9b730fd12cb fe973eb96addc6e=

Peter Eisentraut pushed:

- Cosmetic capitalization fix
http://git.postgresql.org/pg/commitdiff/856a23018c976794655d 6f53b72fb692178=

Robert Haas pushed:

- Remove synchronous_replication/max_wal_senders cross-check. This is
no longer necessary, and might result in a situation where the
configuration file is reloaded (and everything seems OK) but a
subsequent restart of the database fails. Per an observation from
Fujii Masao.
http://git.postgresql.org/pg/commitdiff/19584ec659678841ea30 36336f960acbdae=

- Edits to 9.1 release notes. Add some new items and some additional
details to existing items, mostly by cribbing from the 9.1alpha
notes. Some additional clarifications and corrections elsewhere,
and a few typo fixes.
http://git.postgresql.org/pg/commitdiff/7b630e7b8e4faec13af2 ce934b8bb33d9a1=

- Add post-creation hook for extensions, consistent with other object
types. KaiGai Kohei
http://git.postgresql.org/pg/commitdiff/a432e2783bb69fb68461 ed2bcc460e2876f=

- Make walreceiver send a reply after receiving data but before
flushing it. It originally worked this way, but was changed by
commit a8a8a3e0965201df88bdfdff08f50e5c06c552b7, since which time
it's been impossible for walreceiver to ever send a reply with
write_location and flush_location set to different values.
http://git.postgresql.org/pg/commitdiff/30f6136f28a6bf9eedcb f41038d5b021169=

- Remove alpha release notes. Temporarily move some of the alpha
release note disclaimers into the regular release notes, for the
sake of alpha5.
http://git.postgresql.org/pg/commitdiff/f6f0916dbdf9f2dc6bcd c550d8b3843739c=

- Update release notes for latest commits. In addition, correct the
entry for pg_object_description, and some other minor cleanup.
http://git.postgresql.org/pg/commitdiff/ab1ef8e4448d276d65ec d02bebc03c03854=

- Remove disclaimer stating that fsync=3Doff slows down sync rep. The
underlying problem that caused this phenomenon was fixed by commit
http://git.postgresql.org/pg/commitdiff/de592e2669380d5f9576 6d2bbe583558772=

- Correct "characters" to "bytes" in createdb docs. Susanne Ebrecht.
http://git.postgresql.org/pg/commitdiff/de32982242416ca0c78f 8e8de4e4cd44af1=

- Typo fix in SSI docs. Kevin Grittner
http://git.postgresql.org/pg/commitdiff/20a1159fccd2c4580e5e 1c9782cb98f95c4=

Michael Meskes pushed:

- Documented some ecpg command line options that were missing: -r
no_indicator, -r prepare, and -r questionsmarks
http://git.postgresql.org/pg/commitdiff/71ac48fd9cebd3d2a873 635a04df64096c9=

Alvaro Herrera pushed:

- Fix broken markup, and remove tabs.
http://git.postgresql.org/pg/commitdiff/01dd34d55ad53117c2d7 56da7f65b6fa07a=

Gregory Stark pushed:

- fix up a couple non-prototypes of the form foo() to be foo(void) --
found using -Wstrict-prototypes
http://git.postgresql.org/pg/commitdiff/7b66e2c086b1a24d8ada d52842725db8c04=

== Abgelehnte Patches (bis jetzt) ==

Gurjeet Singh's patch to add a missing semicolon to parser's gram.y.
Similar patch already applied.

== Eingesandte Patches ==

Piyush Newe sent in another revision of the patch intended to fix
to_date()'s behavior to be more consistent with Oracle's.

Bernd Helmle sent in a patch to make psql's \dt use the
pg_table_size() function, which includes things like TOAST tables.

Heikki Linnakangas sent in a patch to fix a bug in initdb on Windows
in Chinese locales.

Fujii Masao sent in a patch to enable standby servers to connect
during smart shutdown in order to wake up backends waiting for sync

Heikki Linnakangas sent in another revision of the replication server
timeout patch.

Gianni Ciolli sent in a doc patch to clarify the limits in size of the

Radoslaw Smogura sent in another revision of the patch to add a second
level of buffer cache.

Robert Haas sent in another revision of the crash-safe visibility map

Robert Haas sent in a patch to allow the safe removal of write
location from sync rep.

Peter Eisentraut sent in a patch to add a feature to "make
maintainer-check" to check for tabs in SGML.

Matthew Draper sent in a WIP patch to allow SQL language functions to
reference parameters by parameter name.

Simon Riggs sent in a patch to add more sync rep settings.

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

Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription: