Re: Reaping Temp tables to avoid XID wraparound

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Reaping Temp tables to avoid XID wraparound
Дата
Msg-id 20190218013102.GI1864@paquier.xyz
обсуждение исходный текст
Ответ на Re: Reaping Temp tables to avoid XID wraparound  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Reaping Temp tables to avoid XID wraparound  (James Sewell <james.sewell@jirotech.com>)
Re: Reaping Temp tables to avoid XID wraparound  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On Sun, Feb 17, 2019 at 05:47:09PM +0100, Magnus Hagander wrote:
> We could I guess add a field specifically for temp_namespace_xid or such.
> The question is if it's worth the overhead to do that.

That would mean an extra 4 bytes in PGPROC, which is something we
could live with, still the use-case looks rather narrow to me to
justify that.

> Just having the namespace oid is at least enough to know that there is
> potentially something to go look at it. But it doesn't make for automated
> monitoring very well, at least not in systems that have a larger number of
> databases.

Yep.  It would be good to make sure about the larger picture before
doing something.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] xlogreader: do not read a file block twice
Следующее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: RE: 2019-03 CF Summary / Review - Tranche #2