Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction
Дата
Msg-id 20150923152605.GS295765@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction  (Jeff Dik <jeffdik@finecode.net>)
Ответы Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction
Список pgsql-general
Jeff Dik wrote:

> Is there any way to inspect a multixact via psql to see what transaction ID
> values it has?  I wasn't able to find anything while searching for an hour
> or so.

There's the function pg_get_multixact_members(xid),

=# select * from pg_get_multixact_members('1');

 xid  |  mode
------+--------
 5401 | keysh
 5402 | forupd
...

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Juan Pablo L.
Дата:
Сообщение: Re: numeric data type
Следующее
От: Daniel Begin
Дата:
Сообщение: PostgreSQL and Windows 10 upgrade