public inbox for [email protected]  

help / color / mirror / Atom feed

Section "Routine Reindexing"
2+ messages / 2 participants
[nested] [flat]

* Section "Routine Reindexing"
@ 2003-11-03 19:49 Peter Eisentraut <[email protected]>
  2003-11-03 20:13 ` Re: Section "Routine Reindexing" Josh Berkus <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Peter Eisentraut @ 2003-11-03 19:49 UTC (permalink / raw)
  To: pgsql-docs

The section "Routine Reindexing" (21.2) has been reduced to:

"""
In some situations it is worthwhile to rebuild indexes periodically with
the REINDEX command. (There is also contrib/reindexdb which can reindex an
entire database.) However, PostgreSQL 7.4 has substantially reduced the
need for this activity compared to earlier releases.
"""

Can someone add something that is of substantial value and less hand-wavy?

-- 
Peter Eisentraut   [email protected]




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Section "Routine Reindexing"
  2003-11-03 19:49 Section "Routine Reindexing" Peter Eisentraut <[email protected]>
@ 2003-11-03 20:13 ` Josh Berkus <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2003-11-03 20:13 UTC (permalink / raw)
  To: Peter Eisentraut <[email protected]>; pgsql-docs

Peter,

> """
> In some situations it is worthwhile to rebuild indexes periodically with
> the REINDEX command. (There is also contrib/reindexdb which can reindex an
> entire database.) However, PostgreSQL 7.4 has substantially reduced the
> need for this activity compared to earlier releases.
> """

Is this for the main docs, or for the Annotated release notes?

If for the main docs:

<para>
PostgreSQL 7.4 manages deleted nodes from indexes on tables with many deletes 
and/or updates using the Free Space Map (FSM) as it does for the tables 
themselves (this is a new feature).  If your max_fsm_pages setting in 
postgresql.conf is correctly set and you vacuum regularly, there should be no 
need for reindexing for most databases most of the time.
</para>
<para>
If your settings are not correct or if your database usage pattern is one that 
FSM and vaccum cannot cope with, such as huge batch updates, then you will 
need to reindex some or all of your indexes on the updated fields 
periodically.  You can determine this by watching for sluggish index response 
times and index growth out of proportion to the growth of the underlying 
table.  In order to reindex an entire database, see the contrib/reindexdb 
module in the PostgreSQL source code.  Please note that reindex exclusively 
locks each table while processing.
</para>


-- 
Josh Berkus
Aglio Database Solutions
San Francisco




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-11-03 20:13 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-03 19:49 Section "Routine Reindexing" Peter Eisentraut <[email protected]>
2003-11-03 20:13 ` Josh Berkus <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox