Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Date
Msg-id 24994.1208128127@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM hanging on PostgreSQL 8.3.1 for larger tables  ("Paragon" <lr@pcorp.us>)
Responses Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  ("Paragon" <lr@pcorp.us>)
Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  (Dragan Zubac <zubac@vlayko.tv>)
List pgsql-general
Tree view 
"Paragon" <lr@pcorp.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

pgsql-general by date:

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