Peripheral Links
Header And Logo
Site Navigation
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.9 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 Bernhard (bkw) Weisshuhn