Re: [HACKERS] Foreground vacuum and buffer access strategy

2013-08-16 Thread Robert Haas
On Tue, Aug 13, 2013 at 4:11 PM, Greg Stark wrote: > I'm not convinced using a ring buffer is necessarily that bad even if > you want to vacuum as fast as possible. The reason we use a small ring > buffer is to avoid poisoning the entire cache with vacuum pages, not > to throttle the speed of vacu

Re: [HACKERS] Foreground vacuum and buffer access strategy

2013-08-13 Thread Amit Kapila
On Wed, Aug 14, 2013 at 1:41 AM, Greg Stark wrote: > On Tue, Aug 13, 2013 at 3:45 PM, Robert Haas wrote: >> >> I'm not sure what the right thing to do here is, but I definitely >> agree there's a problem. There are definitely cases where people want >> or indeed need to vacuum as fast as possibl

Re: [HACKERS] Foreground vacuum and buffer access strategy

2013-08-13 Thread Greg Stark
On Tue, Aug 13, 2013 at 3:45 PM, Robert Haas wrote: > > I'm not sure what the right thing to do here is, but I definitely > agree there's a problem. There are definitely cases where people want > or indeed need to vacuum as fast as possible, and using a small ring > buffer is not the way to do th

Re: [HACKERS] Foreground vacuum and buffer access strategy

2013-08-13 Thread Robert Haas
On Mon, Aug 12, 2013 at 11:47 PM, Jeff Janes wrote: > Reviving a very old thread, because I've run into the issue again. > On Tue, May 29, 2012 at 11:58 AM, Robert Haas wrote: >> On Fri, May 25, 2012 at 4:06 PM, Jeff Janes wrote: >>> If I invoke vacuum manually and do so with VacuumCostDelay ==

Re: [HACKERS] Foreground vacuum and buffer access strategy

2013-08-12 Thread Jeff Janes
Reviving a very old thread, because I've run into the issue again. On Tue, May 29, 2012 at 11:58 AM, Robert Haas wrote: > On Fri, May 25, 2012 at 4:06 PM, Jeff Janes wrote: >> If I invoke vacuum manually and do so with VacuumCostDelay == 0, I >> have basically declared my intentions to get this

Re: [HACKERS] Foreground vacuum and buffer access strategy

2012-05-29 Thread Robert Haas
On Fri, May 25, 2012 at 4:06 PM, Jeff Janes wrote: > If I invoke vacuum manually and do so with VacuumCostDelay == 0, I > have basically declared my intentions to get this pain over with as > fast as possible even if it might interfere with other processes. > > Under that condition, shouldn't it u

[HACKERS] Foreground vacuum and buffer access strategy

2012-05-25 Thread Jeff Janes
If I invoke vacuum manually and do so with VacuumCostDelay == 0, I have basically declared my intentions to get this pain over with as fast as possible even if it might interfere with other processes. Under that condition, shouldn't it use BAS_BULKWRITE rather than BAS_VACUUM? The smaller ring si