| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Doug McNaught <doug(at)wireboard(dot)com>, carex <bk226157(at)skynet(dot)be>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: index files still growing |
| Date: | 2001-10-24 17:59:01 |
| Message-ID: | 200110241759.f9OHx1M22484@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > REINDEX is a marginally prettier answer; at least you don't have to
> > remember the index parameters. Shrinking indexes on-the-fly is still
> > on the TODO list.
>
> But at least in 7.1 REINDEX has to be run under stand-alone Postgres, or
> so say the docs:
>
> REINDEX is used to recover corrupted system indexes. In order to run
> REINDEX command, postmaster must be shut down and stand-alone Postgres
> should be started instead with options -O and -P (an option to ignore
> system indexes).
>
> Whereas the DROP INDEX/CREATE INDEX method works on-the-fly. You may end
> up running a seqscan somewhere, but that's not so big a problem, IMHO.
The single-user warning is only for system index reindexing.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Smith | 2001-10-24 18:13:56 | Re: Progress, anything in common with PostgreSQl besides clever name? |
| Previous Message | Bruce Momjian | 2001-10-24 17:57:39 | Re: Progress, anything in common with PostgreSQl besides clever |