Re: [GENERAL] freeze cannot be finished

2013-11-18 Thread Heikki Linnakangas
On 14.11.2013 02:26, Jeff Janes wrote: On Wed, Nov 13, 2013 at 3:53 PM, Sergey Burladyan wrote: Jeff Janes writes: If I not mistaken, looks like lazy_scan_heap() called from lazy_vacuum_rel() (see [1]) skip pages, even if it run with scan_all == true, lazy_scan_heap() does not increment scann

Re: [GENERAL] freeze cannot be finished

2013-11-13 Thread Jeff Janes
On Wed, Nov 13, 2013 at 3:53 PM, Sergey Burladyan wrote: > Jeff Janes writes: > > If I not mistaken, looks like lazy_scan_heap() called from > lazy_vacuum_rel() > (see [1]) skip pages, even if it run with scan_all == true, > lazy_scan_heap() > does not increment scanned_pages if lazy_check_needs_

Re: [GENERAL] freeze cannot be finished

2013-11-13 Thread Sergey Burladyan
Jeff Janes writes: If I not mistaken, looks like lazy_scan_heap() called from lazy_vacuum_rel() (see [1]) skip pages, even if it run with scan_all == true, lazy_scan_heap() does not increment scanned_pages if lazy_check_needs_freeze() return false, so if this occurred at wraparound vacuum it cann

Re: [GENERAL] freeze cannot be finished

2013-11-13 Thread Jeff Janes
On Wed, Nov 13, 2013 at 7:29 AM, Миша Тюрин wrote: > > Hello! > We are experiencing suspicious and very painful case in our > top-business-critical database. We have only 7 weeks before emergency stop > of the cluster cause wraparound task in autovacuum process can not be > finished again and aga

Re: [GENERAL] freeze cannot be finished

2013-11-13 Thread Tom Lane
=?UTF-8?B?0JzQuNGI0LAg0KLRjtGA0LjQvQ==?= writes: > We are experiencing suspicious and very painful case in our > top-business-critical database. We have only 7 weeks before emergency stop of > the cluster cause wraparound task in autovacuum process can not be finished > again and again. I'm be