|| ||David Fetter <david-AT-fetter.org>|
|| ||PostgreSQL Announce <pgsql-announce-AT-postgresql.org>|
|| ||[ANNOUNCE] == PostgreSQL Weekly News - January 29 2006 ==|
|| ||Sun, 29 Jan 2006 23:42:33 -0800|
== 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
== PostgreSQL Product News ==
Continuent has released p/Cluster, a query multiplexer for PostgreSQL
Bricolage 1.8.0 and 1.10.0 are out, now with lots of bug fixes and new features.
Slony 1.1.5 is out, now with 8.1 compatibility and lots of bug fixes.
Official Solaris packages are out. Kudos to Devrim Gunduz and Josh
Berkus for their hard work on this.
== PostgreSQL Local ==
Everything this week was global.
== PostgreSQL in the News ==
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, published on Mondays (PST/PDT):
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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
to post comments)