[ANN]VTD-XML 2.0
От | Jimmy Zhang |
---|---|
Тема | [ANN]VTD-XML 2.0 |
Дата | |
Msg-id | 020a01c75aab$be41f6d0$0d02a8c0@ximpleware обсуждение исходный текст |
Ответ на | How often do I need to reindex tables? ("Dhaval Shah" <dhaval.shah.m@gmail.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: