Horton

Re: Buglist

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Vivek Khera <khera@kcilink.com>
Cc: pgsql-general@postgresql.org
Date: 2003-08-27T15:05:47Z
Lists: pgsql-hackers, pgsql-general 
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