Re: Transactions to create pg_multixact members and offsets

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: Transactions to create pg_multixact members and offsets
Дата
Msg-id CALSLE1N4w9LQkr=VpVMetdK6YaM3D979mkjWX+ZUVs6YjhbZFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Transactions to create pg_multixact members and offsets  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Transactions to create pg_multixact members and offsets  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
On Thu, Nov 20, 2014 at 11:15 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Search for "burnmulti" in the archives, which is a contrib module to
test pg_multixact.
Thanks, got some links. Will give a try and get back.

Merely waiting does not, but more than one lock being acquired on a
tuple does cause a multixact to be created.  Try SELECT FOR SHARE on two
transactions on the same tuple.
Sure.
Also what if there are only inserts/updates which transaction have and there are no explicit select queries?

Regards...

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

Предыдущее
От: Marcos Cano
Дата:
Сообщение: Re: pgdump (9.2.4) not dumping all tables
Следующее
От: zach cruise
Дата:
Сообщение: Re: better architecture?