== PostgreSQL Weekly News - November 22nd 2004 ==

== PostgreSQL Weekly News - November 22nd 2004 ==

After a month of development, this week saw the release of PostgreSQL 8.0.0
Beta 5. It should be available from your local mirror and the bittorrent
site, for full information check out the official release announcement
(http://archives.postgresql.org/pgsql-announce/2004-11/msg00005.php) Those
testing the native windows and Cygwin releases should also look for new
builds as well.

Given our late date of the beta testing process, we had a pretty good number
of fixes put in over the last week. The win32 problems with signals and
sockets have been resolved. A couple of backend crash scenarios were fixed;
one involving creating tables with more than 65K columns, and one when
processing select queries with more than 65K target list entries. The default
size of the local lock hash table was reduced, speeding up subtransaction
entry and exit. Stat reporting has been changed to occur at transaction
commit time to avoid confusing autovacuum when an updating transaction runs
for a long time. Some new options were added to pg_autovacuum to support
setting the cost-based-vacuum parameters differently from their default
values. Updates to pg_database are now forced out to disk immediately after
ALTER DATABASE, avoiding scenarios where an incoming backend finds no live
copies of a database's row.

Plpgsql's handeling of SPI execution during an exception block was changed to
continue using the old connection rather than starting a new SPI connection.
This fixing some memory mangement issues that had been recently reported.
Several fixes also went in for plperl including cleaning up some compiler
warnings, consolidating some duplicate code, improve the checking of the type
of data returned from perl, adjusting of the safety restrictions, and
modifying error handling within functions.

== PostgreSQL Product News ==

Daffodil Software Open Sources synchronization tool at SourceForge.net
http://www.daffodildb.com/daffodil-opensources-news.html

LatinSecurity AwakE v3.1
http://www.linuxelectrons.com/article.php/20041120141845306

FmPro Migrator 2.57 Enterprise Edition
http://www.prweb.com/releases/2004/11/prwebxml179639.php

ANN: DBManager 3.0
http://archives.postgresql.org/pgsql-general/2004-11/msg00769.php

== PostgreSQL In The News ==

Introducing Slony
http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html

SDForum: Open source becoming first option
http://www.computerworld.com.au/index.php/id;1747676449;fp;16;fpid;0

PostgreSQL vs. MySQL - a subjective view (blog)
http://www.gnegg.ch/archives/prosgresql_vs_mysql_a_subjective_view.html

== PostgreSQL Events ==

PostgreSQL Seminar: Ankura, Turkey: December 1
Devrim Gunduz will present a seminar about upcoming features of PostgreSQL 8.0
http://seminer.linux.org.tr

== PostgreSQL Weekly News - November 22nd 2004 ==
On the Web:
http://www.postgresql.org