Peripheral Links
Header And Logo
Site Navigation
PostgreSQL Weekly News - May 07 2006
Heikki Linnakangas and Tom Lane have rewritten btree index scans to work a page at a time in all cases. In addition to from simplifying and (sometimes) speeding up the indexscan code, this will allow us to reimplement btbulkdelete as a largely sequential scan instead of index-order traversal, significantly reducing the cost of VACUUM. http://archives.postgresql.org/pgsql-committers/2006-05/msg00050.php
Bruce Momjian added SSL CRL support to libpq. http://archives.postgresql.org/pgsql-committers/2006-05/msg00039.php http://archives.postgresql.org/pgsql-committers/2006-05/msg00044.php
Larry Rosenman of Pervasive has submitted a patch for CVS TIP which adds four new timestamp fields to the pg_stat_all_tables view: last_vacuum, last_autovacuum, last_analyze and last_autoanalyze. This will make it easier for people and tools to track "table maintenance" actions.
Teodor Sigaev added Generalized Inverted Indexes (GIN) to CVS TIP. This will help with the upcoming tsearch3, among other things.
How to get metadata: a tutorial. http://www.alberton.info/postgresql_meta_info.html
Registration for the PostgreSQL Anniversary is open http://conference.postgresql.org/Registration
The PostgreSQL Anniversary Summit is brought to you by Afilias, EnterpriseDB, GreenPlum, Pervasive and Sun Microsystems.
PostgreSQL Product News
DBD::Pg 1.49 is out http://search.cpan.org/~dbdpg/DBD-Pg-1.49/
PostgresPy Package Release 0.1 containing Proboscis 0.2 (the new driver), Slythe 0.1 (the new "Remote Console"), and Boss 0.1 (the new "Controller") is out.
http://python.projects.postgresql.org/
Komo PostgreSQL plugin for Eclipse released. http://pgfoundry.org/projects/komo-client/
Devrim Gunduz's vim colorizing file now handles PL/PgSQL syntax. http://www.gunduz.org/postgresql/pgsql.vim
Native PostgreSQL driver sdbc 0.7.1 for OpenOffice.org released. http://dba.openoffice.org/drivers/postgresql/index.html
PostgreSQL Local
Everything this week was global.
PostgreSQL in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, published on Mondays (PST/PDT): http://www.varlena.com/GeneralBits/
PostgreSQL Weekly News is brought to you this week by David Fetter, Lorenzo Alberton and Volkan (knt) Yazici