== PostgreSQL Weekly News - January 26th 2004 ==
От | Robert Treat |
---|---|
Тема | == PostgreSQL Weekly News - January 26th 2004 == |
Дата | |
Msg-id | 200401262137.55689.xzilla@users.sourceforge.net обсуждение исходный текст |
Список | pgsql-announce |
== PostgreSQL Weekly News - January 26th 2004 == Another fine week of development capped off by a late-edition weekly news :-) A number of items to run through and a structural change of note, so let's get to it. A couple of fixes put in this week were back-patched into the 7.4 branch for inclusion into the next release. One fix was a missed optimization in the executor to avoid unnecessary projections when scanning tables where all columns are needed was put in, thanks to Mike Mascari for the initial report. Another bug in pg_dump setting incorrect database LOCATION for 7.0.* servers was fixed, and a problem with dropped column in pltcl triggers, reported by Patrick Salmon, was also fixed. On the main branch, some low level discussions on the GEQO algorithm, and close expection from Tom Lane, have lead to changes in some of the default GEQO parameters, knowledge of SQL heuristics inside GEQO, and improved documentation on the subject.Jan Wieck has also implemented a first pass at background writer functionality, giving folks running dedicated servers a way to improve variance of i/o operations of the server. Neil Conway spent some time cleaning up psql's memory manipulation. ECPG added WHENEVER NOT_FOUND functionality to SELECT/INSERT/UPDATE/DELETE syntax. A behavioral change was put in to allow folks to set a schema search path that includes non-existent schema. In the past, this would have resulted in an ERROR, but this functionality is needed by pg_dump in some restoration cases, so it now emits a NOTICE. There were also a couple of documentation improvements including the addition of an example illustrating how to call functions that take composite types was added into the docs. Some examples on using PREPARE and EXECUTE functionality were also added. One last item was the final removal of the remaining JDBC Driver code was moved out of the main source tree and given it's own project page on gborg at http://gborg.postgresql.org/project/pgjdbc/projdisplay.php, and of course http://jdbc.postgresql.org will also continue to work. Hopefully this will allow the JDBC folks to do more independent releases and not be tied down to the main source releases. == PostgreSQL Product News == Sun Cobalt update for PostgreSQL http://www.secunia.com/advisories/10674/ OpenFTS 0.36 Released http://freshmeat.net/projects/openfts/?branch_id=19183&release_id=149197&topic_id=93 == PostgreSQL In the News == Linux World Expo - Day 2 http://www.freebsddiary.org/linuxworldexpo-2004-part5.php More Agencies Pick Open Source Software http://www.govexec.com/features/1203/1203managetech.htm == Upcoming Events == New York PHP Meeting: New York, New York: January 27 Bruce Momjian will be presenting an introduction to PostgreSQL http://nyphp.org/content/calendar/view_entry.php?id=50&date=20040127 NordU Usenix 2004: Denmark: January 28 - January 30 Bruce Momjian will still be giving his PostgreSQL tutorial http://www.nordu.org/NordU2004/ Linux Solutions 2004: Paris, France: February 3-5 Bruce Momjian will be presenting http://www.solutionslinux.fr/en/index.php == PostgreSQL Weekly News - January 26th 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 по дате отправления: