== PostgreSQL Weekly News - January 29 2006 ==

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