== PostgreSQL Weekly News - March 22nd 2004 == - Mailing list 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