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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2006-01-30 18:45:07 | Erratum: Re: == PostgreSQL Weekly News - January 29 2006 == |
Previous Message | James William Pye | 2006-01-29 17:20:56 | PL/Py version 0.3 Release |