Dev Kumkar wrote:
> Hellos,
>
> How to manually increase pg_multixact members and offsets?
Search for "burnmulti" in the archives, which is a contrib module to
test pg_multixact.
> Does a transaction waiting for exclusive lock or shared lock result into
> entry being created in pg_multixact?
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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services