Skip site navigation (1) Skip section navigation (2)

== PostgreSQL Weekly News - January 29 2006 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - January 29 2006 ==
Date: 2006-01-30 07:42:33
Message-ID: 20060130074233.GB6212@fetter.org (view raw or flat)
Thread:
Lists: pgsql-announce
== PostgreSQL Weekly News - January 29 2006 ==

Stephan Vollmer reported low GiST indexing performance with tsearch2.
Tom Lane and Martijn van Oosterhout investigated and after some
discussion on the performance list they identified a bit counting
function as the culprit. Tom committed an alternative implementation
using a static lookup table to various contrib modules (intarray,
ltree, trgm and tsearch2) that resulted in a 20x performance
improvement for large indexes. Discussion about further improving the
so called "picksplit" algorithm for another 10x gain ensued but did
not reach a conclusive resolution, at least not for the 8.1 branch.

Andrew Dunstan has published an article on PL/Perl
http://www.onlamp.com/pub/a/databases/2006/01/19/more-perl-in-postgresql.html

== PostgreSQL Product News ==

Continuent has released p/Cluster, a query multiplexer for PostgreSQL
http://continuent.com/index.php?option=com_content&task=view&id=212&Itemid=169

Bricolage 1.8.0 and 1.10.0 are out, now with lots of bug fixes and new features.
http://www.bricolage.cc/

Slony 1.1.5 is out, now with 8.1 compatibility and lots of bug fixes.
http://gborg.postgresql.org/project/slony1/news/newsfull.php?news_id=260

Official Solaris packages are out.  Kudos to Devrim Gunduz and Josh
Berkus for their hard work on this.
http://pgfoundry.org/projects/solarispackages/

== PostgreSQL Local ==

Everything this week was global.

== PostgreSQL in the News ==

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

General Bits, published on Mondays (PST/PDT):
http://www.varlena.com/GeneralBits/
Vote For Your Favorite Bit and Organize Schema Updates

PostgreSQL Weekly News is brought to you this week by David Fetter
and Bernhard (bkw) Weisshuhn.

Responses

pgsql-announce by date

Next:From: David FetterDate: 2006-01-30 18:45:07
Subject: Erratum: Re: == PostgreSQL Weekly News - January 29 2006 ==
Previous:From: James William PyeDate: 2006-01-29 17:20:56
Subject: PL/Py version 0.3 Release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group