Vivek Khera wrote: > >>>>> "BM" == Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
