Skip site navigation (1) Skip section navigation (2)

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

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-announce(at)postgresql(dot)org
Subject: == PostgreSQL Weekly News - November 22nd 2004 ==
Date: 2004-11-23 05:50:41
Message-ID: 200411230050.41315.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-announce
== 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


pgsql-announce by date

Next:From: Marc G. FournierDate: 2004-11-23 19:37:56
Subject: Upcoming Changes to News Server ...
Previous:From: Marc G. FournierDate: 2004-11-23 03:28:51
Subject: PostgreSQL 8.0.0 Beta 5 Now Available

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group