Skip to content

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

Der Originalartikel befindet sich unter:

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

== PostgreSQL Produkt Neuigkeiten ==

dtester 0.1, ein ereignisgesteuertes Testwerkzeug, ist

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

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

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

Andreas (ads) Scherbaum hält einen Kurs "PostgreSQL im
Unternehmenseinsatz" an der VHS Magdeburg, Deutschland, vom 03. bis 07.
Mai 2010. Details unter:

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19.

Der CfP für OSBridge ist eröffnet! OSBridge findet vom 1. bis 4.
Juni 2010 in Portland, Oregon statt.

OSCON wird in Portland, Oregon vom 19. bis 23. Juli 2010 stattfinden.

== PostgreSQL in den News ==

Planet PostgreSQL:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an, deutsche an, italienische an

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

- 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

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

- 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.<pid>"
  for the name, but additional workers use
  "pgbench_log.<pid>.<serial-number>" instead.  Reported by Greg

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

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

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

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

  • Twitter
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Wöchentlicher PostgreSQL Newsletter - 28. März 2010
  • Bloglines Wöchentlicher PostgreSQL Newsletter - 28. März 2010
  • Technorati Wöchentlicher PostgreSQL Newsletter - 28. März 2010
  • Fark this: Wöchentlicher PostgreSQL Newsletter - 28. März 2010
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at YahooMyWeb
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 at blogmarks
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 28. März 2010 with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!


No Trackbacks


Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options