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

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

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-announce(at)postgresql(dot)org
Subject: == PostgreSQL Weekly News - March 22nd 2004 ==
Date: 2004-03-23 03:48:50
Message-ID: 200403222248.50921.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-announce
== PostgreSQL Weekly News - March 22nd 2004 ==
                                                                                                          
        This week saw development fall back toward a more normal pace, with 
progress being made on a number of fronts pertaining to planning for new 
features in 7.5, including win32 and PITR among others. While we wait in 
anticipation of "the big ones", let's take a look at a number of other 
improvements made to the 7.5 tree.
                                                                                                          
        Modifications to CASE statement handling to better handle statements 
with very large expression lists was implemented. The btree index build 
routines were modified to now sort equal-keyed tuples according to their TID, 
which avoids using qsort(), which can be quite slow on some platforms. An 
fsync testing tool was added in to help give developers a method for 
determining more appropriate sync methods. Finally, some modifications to 
ensure thread support on Unixware were submitted.
                                                                                                          
        In more feature oriented news, the new log_line_prefix GUC (based on 
7.5's enhanced logging capabilities) was officially added, replacing 
log_statement, log_pid, log_timestamp, and log_source_port. A validation 
routine was added for plpgsql so that minimal syntax checking will now be 
done at creation time for plpgsql functions. Syntax error reporting was also 
modified to give more pleasent results for errors in internally generated 
queries. The pg_dump program was modified to pull over all comments in one 
query rather than pull comments for each object individually. This saves 
substantial time on database with many objects, for example the regression 
test database, where it saves about 33% of time needed to do a schema dump.
                                                                                                          
        In website news, the team is happy to announce that we have at long 
last gotten RSS feeds up for both PostgreSQL news 
(http://www.postgresql.org/news.rss) and events 
(http://www.postgresql.org/events.rss).  Many thanks go out to David Costa 
(http://www.dotgeek.org), who was the driving force in getting these
online.  If you have a content site, please feel free to carry the new feeds; 
or if your favorite site does not carry them please let them know you would 
like to see our feeds carried.


                                                                                  
== PostgreSQL Product News ==
                                                                                                          
PostgreSQL-relay 1.3 Released
http://freshmeat.net/projects/postgresql-relay/?branch_id=47849&release_id=154985
                                                                                                          
SQL4X Manager J 2.7.1 released.
http://www.macosguru.com/macosguru3/press/view.php?id=19


                                                                                           
== PostgreSQL In the News ==
                                                                                                          
Moving from MySQL to PostgreSQL
http://www.dotgeek.org/guruarticles.php?guru=view&id=27
                                                                                                          
postgres ... turtle or hare? (blog)
http://www.deadmime.org/~dank/blog/2004/03/22/postgres_turtle_or_hare.html
                                                                                                          
How to install PostgreSQL 7.4.2 on Windows XP (blog)
http://www.dyrelund.com/index.php?p=24
                                                                                                          
PostgreSQL on OS X (blog)
http://www.randomnetworks.com/joseph/blog/?eid=99
                                                                                                          
M$ SQL Server slips (blog)
http://mayhem-chaos.net/blog/archives/000511.html
                                                                                                          
                                                                                                          
                                                                                                          
== Upcoming Events ==
                                                                                                          
OSCon: Portland, OR. USA: July 26-30
There will be a PostgreSQL Track with several community members participating.
http://conferences.oreillynet.com/os2004/
                                                                                                          
                                                                                                          
                                                                                                          
== PostgreSQL Weekly News - March 22nd 2004 ==
Don't forget to read Elein Mustain's Weekly Summary of the PostgreSQL
General Mailing List http://www.varlena.com/GeneralBits/
                                                                                                          
On the Web:
http://www.postgresql.org
http://advocacy.postgresql.org


pgsql-announce by date

Next:From: Robert TreatDate: 2004-03-30 04:18:29
Subject: == PostgreSQL Weekly News - March 29th 2004 ==
Previous:From: Robert TreatDate: 2004-03-15 19:20:30
Subject: == PostgreSQL Weekly News - March 15th 2004 ==

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