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
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_
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
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
Hello, Tom! Thank you for so fast answer.
We did manual vacuum freeze with delay 10 also but unfortunately vacuum did
nothing with pg_class.relfrozenxid too.
Vacuum delay values like 10-40 work very well for many years in our production
cases.
> It's not terribly surprising that it's failing t
=?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
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 again.
PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled b
