| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Glenn Wiorek <gwiorek(at)jmlafferty(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: rebuild index question |
| Date: | 2003-10-16 19:41:19 |
| Message-ID: | 20031016194119.GA31284@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Oct 16, 2003 at 14:28:09 -0500,
Glenn Wiorek <gwiorek(at)jmlafferty(dot)com> wrote:
> Hello all, It appears that the rebuild index command (driven by contrib/reindexdb) recreates the index with a new oids in the default data directory. This has just caused me a lot of grief to move and relink 329 indices (again) because of space and disk constraints (35 GB to spread across 4 drives). Since rebuilding indexes is a common and often needed task how is everyone working around this?
This should be a lot better in 7.4. Most people should not need to do
reindexes.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Donald Fraser | 2003-10-16 22:35:48 | Re: [PERFORM] backup/restore - another area. |
| Previous Message | Glenn Wiorek | 2003-10-16 19:28:09 | rebuild index question |