Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Paragon" <lr(at)pcorp(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:08:47
Message-ID: 24994.1208128127@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Paragon" <lr(at)pcorp(dot)us> writes:
> Right now I have
> vacuum_cost_delay = 600

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

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