| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shankar K <shan0075(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Rebuild indexes |
| Date: | 2003-07-29 02:21:37 |
| Message-ID: | 17554.1059445297@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Shankar K <shan0075(at)yahoo(dot)com> writes:
> ... so i then decided to do reindex online, but
> that makes exclusive lock on table which would prevent
> writing on to tables.
So does CREATE INDEX, so it's not clear what you're buying with
all these pushups.
> 2. analyze table to update stats, so that the table
> knows about new indexes.
You do not need to ANALYZE to get the system to notice new indexes.
> 4. i wish i had a rename index command to rename _swap
> to its original index name.
You can rename indexes as if they were tables.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shankar K | 2003-07-29 03:00:39 | Re: [ADMIN] Rebuild indexes |
| Previous Message | Josh Berkus | 2003-07-29 00:18:59 | Re: [PERFORM] Rebuild indexes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shankar K | 2003-07-29 03:00:39 | Re: [ADMIN] Rebuild indexes |
| Previous Message | Josh Berkus | 2003-07-29 00:18:59 | Re: [PERFORM] Rebuild indexes |