Re: Re: Loading optimization

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

> * Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)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(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