[ANN]VTD-XML 2.0

XimpleWare is proud to announce the release of version 2.0 of
VTD-XML, the next generation XML parser/indexer. The new
features introduced in this version are:

* VTD+XML version 1.0: the world's first true native XML index
that is simple, general-purpose and back-compatible with XML.
* NodeRecorder Class that saves VTDNav's cursor location for
later sequential access.
* Overwrite capability
* Lexically comparisons between VTD and strings

To download the software, please go to
http://sourceforge.net/project/showfiles.php?group_id=110612

To read the latest benchmark report please go to
http://vtd-xml.sf.net/benchmark1.html

To get the latest API overview
http://www.ximpleware.com/vtd-xml_intro.pdf

----- Original Message -----
From: "Jim C. Nasby" <jim(at)nasby(dot)net>
To: "Dhaval Shah" <dhaval(dot)shah(dot)m(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 27, 2007 11:56 AM
Subject: Re: [GENERAL] How often do I need to reindex tables?

> On Tue, Feb 27, 2007 at 11:26:02AM -0800, Dhaval Shah wrote:
>> I am planning to use 8.2 and the average inserts/deletes and updates
>> across all tables is moderate. That is, it is a moderate sized
>> database with moderate usage of tables.
>>
>> Given that, how often do I need to reindex the tables? Do I need to do
>> it everyday?
>
> No, you should very rarely if ever need to do it.
>
> If you're really concerned, I suggest monitoring average tuples per
> index page; something like
>
> SELECT relname, reltuples/relpages FROM pg_class WHERE relkind = 'i' AND
> relpages > 1000;
>
> That'll show tuples/page for all indexes over 8MB in size.
>
>> Also with 8.2, I do not have to do vacuum anymore or that is what I
>> understand. Does it do auto-vacuum?
>
> You still need to enable autovacuum. See autovacuum_enable.
> --
> Jim Nasby jim(at)nasby(dot)net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>