| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2006-09-26 15:05:24 | Re: pg_hba.conf: 'trust' vs. 'md5' Issues |
| Previous Message | Jeff Frost | 2006-09-26 15:01:24 | Re: pg_hba.conf: 'trust' vs. 'md5' Issues |