Vivek Khera wrote:
> >>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
>
> BM> Hold --- a non-FULL vacuum is taking 6+ hours on two tables? That seems
> BM> impossible.
>
> Well, did I mention I'm saturating my disk I/O bandwidth at the same
> time with other queries? ;-)
But six hours. It is my understanding that a sequential scan is roughly
the same load as a non-FULL vacuum. Are you saying a sequential scan
takes +6 hours too? How can any work get done?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073