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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
adey wrote:
> Hi Tom,
> Further to my request below, the following recommendation exists in the
> Postgres 8.1 documentation:-

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

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                      
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-2017 The PostgreSQL Global Development Group