| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Shankar K <shan0075(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Rebuild indexes |
| Date: | 2003-07-29 00:18:59 |
| Message-ID: | 200307281718.59127.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Shankar,
> Is there a better way to do this. comments are
> appreciated.
No. This is one of the major features in 7.4; FSM and VACUUM will manage
indexes as well. Until then, we all suffer ....
BTW, the REINDEX command is transaction-safe. So if your database has "lull"
periods, you can run it without worrying that any updates will get turned
back.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-29 02:21:37 | Re: Rebuild indexes |
| Previous Message | Romildo Wildgrube | 2003-07-29 00:12:59 | Partition DB Tables by month |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-29 02:21:37 | Re: Rebuild indexes |
| Previous Message | Shankar K | 2003-07-28 21:29:05 | Rebuild indexes |