On 2021-Mar-02, David Rowley wrote:
> However, I wonder if it's worth going a few steps further to try and
> reduce the chances of that message being seen in the first place.
> Maybe it's worth considering ditching any (auto)vacuum cost limits for
> any table which is within X transaction from wra
On Wed, Mar 3, 2021 at 7:10 AM Hannu Krosing wrote:
> On Wed, Mar 3, 2021 at 11:33 AM David Rowley wrote:
> > On Wed, 3 Mar 2021 at 21:44, Magnus Hagander wrote:
> >
> > I meant to ignore the cost limits if we're within a hundred million or
> > so of the stopLimit. Per what Hannu mentioned, the
On Wed, Mar 3, 2021 at 11:33 AM David Rowley wrote:
>
> On Wed, 3 Mar 2021 at 21:44, Magnus Hagander wrote:
...
> > I think we misunderstand each other. I meant this only as a comment
> > about the idea of ignoring the cost limit in single user mode -- that
> > is, it's a reason to *want* vacuum
On Wed, 3 Mar 2021 at 21:44, Magnus Hagander wrote:
>
> On Tue, Mar 2, 2021 at 10:07 PM David Rowley wrote:
> >
> > On Wed, 3 Mar 2021 at 01:12, Magnus Hagander wrote:
> > >
> > > On Tue, Mar 2, 2021 at 7:52 AM David Rowley wrote:
> > > > I have seen it happen that an instance has a vacuum_cost
On Tue, Mar 2, 2021 at 10:07 PM David Rowley wrote:
>
> On Wed, 3 Mar 2021 at 01:12, Magnus Hagander wrote:
> >
> > On Tue, Mar 2, 2021 at 7:52 AM David Rowley wrote:
> > > I have seen it happen that an instance has a vacuum_cost_limit set and
> > > someone did start the database in single-user
On Wed, 3 Mar 2021 at 01:12, Magnus Hagander wrote:
>
> On Tue, Mar 2, 2021 at 7:52 AM David Rowley wrote:
> > I have seen it happen that an instance has a vacuum_cost_limit set and
> > someone did start the database in single-user mode, per the advice of
> > the error message only to find that t
On Tue, Mar 2, 2021 at 7:52 AM David Rowley wrote:
>
> On Tue, 2 Mar 2021 at 04:32, Hannu Krosing wrote:
> >
> > It looks like we are unnecessarily instructing our usiers to vacuum their
> > databases in single-user mode when just vacuuming would be enough.
> >
> > We should fix the error message
On Tue, 2 Mar 2021 at 04:32, Hannu Krosing wrote:
>
> It looks like we are unnecessarily instructing our usiers to vacuum their
> databases in single-user mode when just vacuuming would be enough.
>
> We should fix the error message to be less misleading.
It would be good to change the message as
On Mon, Mar 01, 2021 at 04:32:23PM +0100, Hannu Krosing wrote:
> It looks like we are unnecessarily instructing our usiers to vacuum their
> databases in single-user mode when just vacuuming would be enough.
> When I started looking at improving the situation I discovered, that there
> already is
