Skip to content

Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008


Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/


== Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 ==

Das Juli Commitfest ist fast vorüber und viele neue Features wurden
hinzugefügt.

== PostgreSQL Produkt Neuigkeiten ==

Benetl 2.2 erschienen.
http://www.benetl.net

check_postgres 2.1.0 erschienen.
http://bucardo.org/check_postgres/

pgpool-II 2.1 erschienen.
http://pgfoundry.org/frs/shownotes.php?group_id=1000055&release_id=1187

== PostgreSQL Jobs im Juli ==

http://archives.postgresql.org/pgsql-jobs/2008-07/threads.php

== PostgreSQL Lokal ==

Sponsere den Europäischen PostgreSQL Tag!
http://www.pgday.org/en/sponsors/campaign

Der Call for Papers für den Europäischen PostgreSQL Tag hat begonnen.
http://www.pgday.org/en/call4papers

pgDay San Francisco wird am 5. August stattfinden. Programm:
http://pugs.postgresql.org/node/447
Anmeldung hier:
http://www.linuxworldexpo.com/live/12/ehall//SN460564

PGCon Brazil 2008 wird vom 26.-27. September auf dem Unicamp in
Campinas stattfinden.
http://pgcon.postgresql.org.br/index.en.html

PGDay.(IT|EU) 2008 wird am 17. und 18. Oktober in Prato stattfinden.
http://www.pgday.org/it/

== PostgreSQL in den News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

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

Tom Lane committed:

- In pgsql/src/backend/commands/prepare.c, add comment about the two
different query strings that ExecuteQuery() has to deal with.

- In pgsql/doc/src/sgml/gin.sgml, update link to Oleg and Teodor's GIN
page. (Extracted from fast-insert patch, since it ought to be
back-patched)

- Use guc.c's parse_int() instead of pg_atoi() to parse fillfactor in
default_reloptions(). The previous coding was really a bug because
pg_atoi() will always throw elog on bad input data, whereas
default_reloptions is not supposed to complain about bad input
unless its validate parameter is true. Right now you could only
expose the problem by hand-modifying pg_class.reloptions into an
invalid state, so it doesn't seem worth back-patching; but we should
get it right in HEAD because there might be other situations in
future. Noted while studying GIN fast-update patch.

- In pgsql/src/backend/libpq/hba.c, remove some redundant tests and
improve comments in next_token(). Cosmetic, but it might make this
a bit less confusing to the next reader.

- In pgsql/src/backend/libpq/auth.c, fix parsing of LDAP URLs so it
doesn't reject spaces in the "suffix" part. Per report from Cesar
Miguel Oliveira Alves.

- As noted by Andrew Gierth, there's really no need any more to force
a junk filter to be used when INSERT or SELECT INTO has a plan that
returns raw disk tuples. The virtual-tuple-slot optimizations that
were put in place awhile ago mean that ExecInsert has to do
ExecMaterializeSlot, and that already copies the tuple if it's raw
(and does so more efficiently than a junk filter, too). So get rid
of that logic. This in turn means that we can throw away
ExecMayReturnRawTuples, which wasn't used for any other purpose, and
was always a kluge anyway. In passing, move a couple of
SELECT-INTO-specific fields out of EState and into the private state
of the SELECT INTO DestReceiver, as was foreseen in an old comment
there. Also make intorel_receive use ExecMaterializeSlot not
ExecCopySlotTuple, for consistency with ExecInsert and to possibly
save a tuple copy step in some cases.

Alvaro Herrera committed:

- In pgsql/src/backend/postmaster/autovacuum.c, publish more openly
the fact that autovacuum is working for wraparound protection.
Simon Riggs.

- In pgsql/src/backend/postmaster/autovacuum.c, ratchet up patch to
improve autovacuum wraparound messages. Simon Riggs.

Peter Eisentraut committed:

- Abort if Tcl support was configured and no tcl shell was found.
This is required because the value is substituted into the
pltcl_*mod scripts.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Markus Wanner sent in a patch to rename query_string to prepared_qs.

Robert Lor sent in a revised patch for dtrace probes.

David Gould sent in a patch for pg_dumpall which adds a
--lock-wait-timeout parameter similar to the one he added for pg_dump.

Simon Riggs sent in revision of his patch to make autovacuum report
when it is preventing a transaction ID wraparound for CVS HEAD and
8.3.

Simon Riggs sent in two more revisions of a patch to add
--schema-before-data and --schema-after-data options to pg_dump.

Xiao Meng sent in another version of his patch to improve performance
on hash indexes.

Robert Haas sent in a patch to add a separate permission for TRUNCATE.

Tatsuo Ishii sent in three more revisions of Yoshiyuki Asaba's patch
to implement CTEs.

Simon Riggs sent a patch to add a contrib module which adds a
Transportable Optimizer Mode to PostgreSQL.
  • Twitter
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008
  • Bloglines Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008
  • Technorati Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008
  • Fark this: Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at YahooMyWeb
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at Furl.net
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at reddit.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at blinklist.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at Spurl.net
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at Simpy.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 at blogmarks
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 27. Juli 2008 with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

No Trackbacks

Comments

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