[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@nasby.net>
To: "Dhaval Shah" <dhaval.shah.m@gmail.com>
Cc: <pgsql-general@postgresql.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@nasby.net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>