Re: vacuum locking - Mailing list pgsql-performance

From Tom Lane
Subject Re: vacuum locking
Date
Msg-id 1113.1067534927@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum locking  (Rob Nagler <nagler@bivio.biz>)
List pgsql-performance
Rob Nagler <nagler@bivio.biz> writes:
> When vacuum is running, it's going through the entire
> database, and that pretty much trashes all other queries, especially
> DSS queries.  As always it is just software, and there's got to be
> 80/20 solution.

One thing that's been discussed but not yet tried is putting a tunable
delay into VACUUM's per-page loop (ie, sleep N milliseconds after each
heap page is processed, and probably each index page too).  This might
be useless or it might be the 80/20 solution you want.  Want to try it
and report back?

            regards, tom lane

pgsql-performance by date:

Previous
From: Rob Nagler
Date:
Subject: Re: vacuum locking
Next
From: "scott.marlowe"
Date:
Subject: Re: vacuum locking