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 st...@mit.edu 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

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 jeff.ja...@gmail.com 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 robertmh...@gmail.com wrote: On Fri, May 25, 2012 at 4:06 PM, Jeff Janes jeff.ja...@gmail.com wrote: If I

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 robertmh...@gmail.com 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

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 st...@mit.edu wrote: On Tue, Aug 13, 2013 at 3:45 PM, Robert Haas robertmh...@gmail.com 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

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 robertmh...@gmail.com wrote: On Fri, May 25, 2012 at 4:06 PM, Jeff Janes jeff.ja...@gmail.com wrote: If I invoke vacuum manually and do so with VacuumCostDelay == 0, I have

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 jeff.ja...@gmail.com 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

[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