rebuild index question

From: "Glenn Wiorek" <gwiorek(at)jmlafferty(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: rebuild index question
Date: 2003-10-16 19:28:09
Message-ID: 008e01c3941b$a1f56e30$143264c8@jmlafferty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

For that matter how are folks dealing with laying out large databases across multiple drives??

Thanks,
Glenn

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2003-10-16 19:41:19 Re: rebuild index question
Previous Message Tom Lane 2003-10-16 17:51:32 Re: question re double quotes