Re: do only critical work during single-user vacuum?

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: do only critical work during single-user vacuum?
Дата
Msg-id CAFBsxsHbn4atCHRFXtKQs4FWUhaErdvXa1fX_nouq70pUiC8tw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: do only critical work during single-user vacuum?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On Wed, Mar 16, 2022 at 4:48 AM Peter Geoghegan <pg@bowt.ie> wrote:
>
> On Wed, Feb 16, 2022 at 12:43 AM John Naylor
> <john.naylor@enterprisedb.com> wrote:
> > I'll put some effort in finding any way that it might not be robust.
> > After that, changing the message and docs is trivial.
>
> It would be great to be able to totally drop the idea of using
> single-user mode before Postgres 15 feature freeze. How's that going?

Unfortunately, I was distracted from this work for a time, and just as
I had intended to focus on it during March, I was out sick for 2-3
weeks. I gather from subsequent discussion that a full solution goes
beyond just a new warning message and documentation. Either way I'm
not quite prepared to address this in time for v15.

> I suggest that we apply the following patch as part of that work. It
> adds one last final failsafe check at the point that VACUUM makes a
> final decision on rel truncation.

That is one thing that was in the back of my mind, and it seems
reasonable to me.

-- 
John Naylor
EDB: http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: WIP: WAL prefetch (another approach)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: generic plans and "initial" pruning