Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables - Mailing list pgsql-general

From Paragon
Subject Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Date
Msg-id 001201c89dbc$00de99e0$4c812e40@q
Whole thread Raw
In response to Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

> Yikes.  That's *way* too high.  If you're trying to get the vacuum to
complete quickly, it really should be zero anyway.  Nonzero is for when you
don't care how >>  long vacuum takes as long as it's not sucking too much
I/O from your real work.

Thanks Tom, yap you were right now it runs instantaneously by resetting
vacuum back to defaults.  I feel kind of dumb at this point   :)
I guess misunderstood the docs.

Thanks again,
Regina




pgsql-general by date:

Previous
From: Ted Byers
Date:
Subject: Re: No Return??
Next
From: Dragan Zubac
Date:
Subject: Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables