Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables

From: "Paragon" <lr(at)pcorp(dot)us>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Date: 2008-04-13 23:13:37
Message-ID: 001201c89dbc$00de99e0$4c812e40@q
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dragan Zubac 2008-04-13 23:22:57 Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Previous Message Ted Byers 2008-04-13 23:10:57 Re: No Return??