Re: multixacts woes

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: multixacts woes
Дата
Msg-id 20150508201616.GE2658@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: multixacts woes  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On 2015-05-08 12:57:17 -0700, Josh Berkus wrote:
> I have a couple workloads in my pool which do consume mxids faster than
> xids, due to (I think) execeptional numbers of FK conflicts.  It's
> definitely unusual, though, and I'm sure they'd rather have corruption
> protection and endure some more vacuums.  If we do this, though, it
> might be worthwhile to backport the multixact age function, so that
> affected users can check and schedule mxact wraparound vacuums
> themselves, something you currently can't do on 9.3.

That's not particularly realistic due to the requirement of an initdb to
change the catalog.

Greetings,

Andres Freund



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: multixacts woes
Следующее
От: Andres Freund
Дата:
Сообщение: Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0