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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
