User: Password:
|
|
Subscribe / Log in / New account

PostgreSQL Weekly News

From:  David Fetter <david-AT-fetter.org>
To:  PostgreSQL Announce <pgsql-announce-AT-postgresql.org>
Subject:  [ANNOUNCE] == PostgreSQL Weekly News - March 11 2007 ==
Date:  Sun, 11 Mar 2007 22:44:16 -0700

== PostgreSQL Weekly News - March 11 2007 ==

A lively discussion continues on -hackers about automatically creating
partitions.

== PostgreSQL Product News ==

Phil Endecott has created a new C++ binding for PostgreSQL.
http://svn.chezphil.org/libpbe/trunk/doc/Database

Security Enhanced PostgreSQL (SE-PostgreSQL) 8.2.3-1.0 alpha released.
http://code.google.com/p/sepgsql/

Slony-I 1.1.7 and 1.2.7 released.
http://main.slony.info/

== PostgreSQL Jobs for March ==

http://archives.postgresql.org/pgsql-jobs/2007-03/threads...

== PostgreSQL Local ==

The Italian PostgreSQL community is looking for sponsors for its
PostgreSQL day in Prato, Italy this summer.  Check the link below
to participate.
http://www.pgday.it

== PostgreSQL in the News ==

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

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News is brought to you this week by David Fetter

To get your submission into the upcoming issue, make sure it arrives
at david@fetter.org or in German at pwn@pgug.de by Sunday at 3:00pm
Pacific Time.

== Applied Patches == 

Andrew Dunstan committed:

- In pgsql/src/test/regress/output/largeobject_1.source, add alternate
  result file for large object tests to handle Windows line ends.

Teodor Sigaev committed:

- Athough cube is a varlena type, nowhere was a detoasting of cube's
  value, so fix it.  Add macroses DatumGetNDBOX, PG_GETARG_NDBOX and
  PG_RETURN_NDBOX.  Backpatch for 8.2 too.  Previous versions use
  version 0 calling conventions. And fmgr code detoast values for
  user-defined functions.

Alvaro Herrera committed:

- Fix a race condition that caused pg_database_size() and
  pg_tablespace_size() to fail if an object was removed between calls
  to ReadDir() and stat().  Per discussion in pgsql-hackers.
  http://archives.postgresql.org/pgsql-hackers/2007-03/msg0...
  Bug report and patch by Michael Fuhr.

- Clean up the bootstrap code a little, and rename "dummy procs" in
  the code comments and variables to "auxiliary proc", per Heikki's
  request.

Tom Lane committed:

- Fix vac_update_relstats to ensure it always sends a relcache inval
  message, even if none of the fields in the pg_class row change.
  This behavior is necessary to ensure other backends flush
  rd_targblock values that might point to truncated-away pages.  We
  got this right pre-8.2 but it was broken by overoptimistic change to
  not write out the pg_class row if unchanged.  Per report from Pavan
  Deolasee.

- Fix oversight in original coding of inline_function(): since
  check_sql_fn_retval allows binary-compatibility cases, the
  expression extracted from an inline-able SQL function might have a
  type that is only binary-compatible with the declared function
  result type.  To avoid possibly changing the semantics of the
  expression, we should insert a RelabelType node in such cases.  This
  has only been shown to have bad consequences in recent 8.1 and up
  releases, but I suspect there may be failure cases in the older
  branches too, so patch it all the way back.  Per bug #3116 from Greg
  Mullane.  Along the way, fix an omission in
  eval_const_expressions_mutator: it failed to copy the relabelformat
  field when processing a RelabelType.  No known observable failures
  from this, but it definitely isn't intended behavior.  

Peter Eisentraut committed:

- Toru SHIMOGAKI's patch which adds more information about avoiding
  Linux OOM killer.

Bruce Momjian committed:

- Minor edits to pgsql/doc/src/sgml/runtime.sgml 

- Revert temp_tablespaces because of coding problems, per Tom Lane.

- In pgsql/src/backend/utils/adt/geo_ops.c, remove copied comments
  from geo_ops.c source file and replace with new comments, and
  cleanup functions.  Remove copyright that is no longer relevant.

- Remove timeline for 8.3 release from FAQ_DEV, as it is now on web
  site.

Magnus Hagander commmitted:

- Remove unsafe calling of WSAStartup and WSACleanup from DllMain.
  Move the inline cleanup call around so it will be called in the
  right order, and be called on errors.  Per report from Tokuharu
  Yuzawa.

- Add script to build documentation on win32 without mingw.

- Remove old-style win32 client-only visual c++ build infrastructure
  for everything except libpq. We need to keep libpq to build static
  libraries and to use PQtrace with clients using older versions of
  MSVC.

Neil Conway committed:

- Heikki Linnakangas patch which fixes a typo in a comment in
  pgsql/src/backend/access/nbtree/nbtinsert.c.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Zoltan Boszormenyi sent in one more version of his IDENTITY/GENERATED
patch.

Nikolay Samokhvalov sent in another version of his xpath_array()
patch.

ITAGAKI Takahiro sent in a patch which automatically adjusts
bgwriter_lru_maxpages.

ITAGAKI Takahiro sent in a patch to speed up pg_bench.

Simon Riggs sent in a patch which lets people do some heap page
diagnostics.

Mike Rylander sent in a patch against contrib/xml2 which adds support
for default XML namespaces.

Trevor Hardcastle sent in a patch which adds support for CREATE TABLE
LIKE INCLUDING INDEXES.

Tatsuhito Kasahara sent in a patch to fix a bug reporting a value of
strange leaf_fragmentation.

Pavan Deolasee sent in version 4.1 of his HOT WIP patch, this one with
some optimizations for efficiently looking up LP_DELETEd tuples and
some new logic to clean up row level fragmentation.

Gregory Stark sent in another version of his packed varlenas patch,
now with bug fixes and new regression tests.

Simon Riggs sent in a patch to add new functions that  examine the
contents of heap pages, as discussed recently on -hackers.

Simon Riggs sent in a patch which adds a new GUC variable:
log_autovacuum.

Simon Riggs sent in two versions of a patch to implement buffer cache
recycling for scans, as being discussed on pgsql-hackers.

Gregory Stark sent in a patch which implements WITH (not RECURSIVE).

Gregory Stark sent in another version of his compact varlena patch,
now with a special case for little-endian machines.

Heikki Linnakangas sent in a patch documenting that CLUSTER isn't
MVCC-safe.

Tom Lane sent in a WIP patch for plan invalidation.



---------------------------(end of broadcast)---------------------------
-To unsubscribe from this list, send an email to:

               pgsql-announce-unsubscribe@postgresql.org


(Log in to post comments)


Copyright © 2007, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds