Обсуждение: == 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.
On Sun, Jan 29, 2006 at 11:42:33PM -0800, David Fetter wrote: The Bricolage announcement should read: Bricolage 1.8.9 and 1.10.0 are out, now with lots of bug fixes and new features. http://www.bricolage.cc/ Regards, David. -- David Fetter david@fetter.org http://fetter.org/ phone: +1 415 235 3778 Remember to vote!