Skip site navigation (1) Skip section navigation (2)

Re: WAL configuration and REINDEX

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: adey <adey11(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL configuration and REINDEX
Date: 2006-09-26 15:02:19
Message-ID: 20060926150219.GV6330@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
adey wrote:
> Hi Tom,
> Further to my request below, the following recommendation exists in the
> Postgres 8.1 documentation:-
> http://www.postgresql.org/docs/8.1/interactive/routine-reindex.html

Did you actually read that page?  It says that there are some
circumstances under which reindex is still required, but they should be
rare.

It doesn't have anything to do with page splits though.  The problem is
with page merging not being implemented (contiguous partially-filled
pages are not merged)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-admin by date

Next:From: Jeff FrostDate: 2006-09-26 15:05:24
Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues
Previous:From: Jeff FrostDate: 2006-09-26 15:01:24
Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group