Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Indexes growing continuously
- From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
- To: Mike Mascari <mascarm(at)mascari(dot)com>
- Cc: Daniele Orlandi <daniele(at)orlandi(dot)com>, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Indexes growing continuously
- Date: Tue, 4 Apr 2000 16:47:19 -0400 (EDT)
- Message-id: <200004042047.QAA00150@candle.pha.pa.us> <text/plain>
> > I know I can fix this by recreating the indexes, but I don't know how to > > do it for a system table and if it's safe. > > > > Any hints ? > > Unfortunately, this is a bug in PostgreSQL with respect to system > indexes. You can safely drop/create user indexes, but not system > ones. The only way to reclaim the space used is to dump/reload > your database. Under 7.0, I *believe* Hiroshi's REINDEX command > (please correct me someone if I'm wrong) will allow you to > reconstruct system indexes, but the root problem still exists... pg_upgrade will allow this, without dump/reload of data. -- Bruce Momjian | http://www.op.net/~candle 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
- References:
- Re: Indexes growing continuously
- From: Mike Mascari
- Re: Indexes growing continuously
- Prev by Date: Re: Indexes growing continuously
- Next by Date: RE: CURSOR after hitting end
- Previous by thread: Re: Indexes growing continuously
- Next by thread: postgres crash on CURSORS
- Indexes: