Re: improving wraparound behavior

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: improving wraparound behavior
Дата
Msg-id 20190506070600.5jwpeiw4og3coy7d@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: improving wraparound behavior  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: improving wraparound behavior  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Hi,

On 2019-05-03 23:08:44 -0400, Stephen Frost wrote:
> This makes me think we should both order it and combine it into one
> message... but that'd then be pretty difficult to deal with,
> potentially, from a translation standpoint and just from a "wow, that's
> a huge log message", which is kind of the idea behind the SRF- to give
> you all that info in a more easily digestible manner.
> 
> Not sure I've got any great ideas on how to improve on this.  I do think
> that if we know that there's multiple different things that are within a
> small number of xids of the oldest xmin then we should notify the user
> about all of them, either directly in the error messages or by referring
> them to the SRF, so they have the opportunity to address them all, or
> at least know about them all.  As mentioned though, it's likely to be a
> quite rare thing to run into, so you'd have to be extra unlucky to even
> hit this case and perhaps the extra code complication just isn't worth
> it.

I think just having an actual reason for the problem would be so much
better than the current status, that I'd tackle the "oops, just about
everything is screwed, here's the reasons in order" case separately (or
just plain never).

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: REINDEX INDEX results in a crash for an index of pg_class since9.6
Следующее
От: Rafia Sabih
Дата:
Сообщение: Re: make \d pg_toast.foo show its indices