== PostgreSQL Weekly News - May 07 2006 ==

== 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