Re: Representation of ResourceOwnerIds (transient XIDs) in system views (lazy xid assignment)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Representation of ResourceOwnerIds (transient XIDs) in system views (lazy xid assignment)
Дата
Msg-id 8950.1188415970@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Representation of ResourceOwnerIds (transient XIDs) in system views (lazy xid assignment)  ("Florian G. Pflug" <fgp@phlo.org>)
Ответы Re: Representation of ResourceOwnerIds (transient XIDs) in system views (lazy xid assignment)
Список pgsql-hackers
"Florian G. Pflug" <fgp@phlo.org> writes:
> Since generating transient XIDs (named ResourceOwnerIDs in my patch, since
> their lifetime is coupled to the lifetime of a transaction's toplevel
> resource owner) seems to be to way to go for lazx xid assignment, I need
> to find a way to represent them in the pg_locks view.

This is going very far towards gilding the lily.  Try to avoid loading
the patch down with a new datatype.

I'm inclined to think that it'd be sufficient to show the high half of
the ID (that is, the session number) in pg_locks, because there will
never be cases where there are concurrently existing locks on different
localTransactionIds.  This could probably be displayed in the
transactionID columns, which would mean we're abusing the user-visible
xid datatype, but I don't see much harm in it.
        regards, tom lane


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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: [DOCS] Contrib modules documentation online
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Contrib modules documentation online