Re: When do vacuumed pages/tuples become available for reuse? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: When do vacuumed pages/tuples become available for reuse?
Date
Msg-id 20190411150423.GA7441@alvherre.pgsql
Whole thread Raw
In response to Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Responses Re: When do vacuumed pages/tuples become available for reuse?
List pgsql-general
On 2019-Apr-11, rihad wrote:

> On 04/11/2019 06:41 PM, Alvaro Herrera wrote:
>
> > Perhaps it'd be better to vacuum this table much more often.
> > 
> Each run took 5-6 hours, now it takes 2-3 hours after I've tweaked some
> cost-based vacuum knobs.

But how often does it run?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-general by date:

Previous
From: rihad
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?
Next
From: rihad
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?