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