Re: Re: Loading optimization

We have talked about this, but we have not seen enought corruption cases
to warrant it.


> * Bruce Momjian <pgman@candle.pha.pa.us> [010111 13:12] wrote:
> > Added to TODO (part of this is reorganization of cluster items):
> >
> > * CLUSTER
> >         * cluster all tables at once
> >         * prent lose of constraints, indexes, permissions, inheritance
> >         * Automatically keep clustering on a table
> >         * Keep statistics about clustering, perhaps during VACUUM ANALYZE
> >           [optimizer]
>
> Are there any plans (or maybe it's already done?) for a fsck-like
> utility for postgresql that will automagically drop all indecies,
> scan the table for bad data and then recreate the index, prefereably
> with only an exclusive lock on the database being manipulated(*)?
>
> (*) to avoid having to start up the postmaster with weird options
> and/or stop activity on other databases under the postmaster's
> control.
>
> thanks,
> --
> -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
> "I have the heart of a child; I keep it in a jar on my desk."
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026