Re: pg_multixact/members growing

Tiffany Thang <tiffanythang(at)gmail(dot)com> writes:
> Where do I find pg_controldata? I could not locate it on the file system.

Hmm, should be one of the installed PG executables.

> pg_clog/ or pg_subtrans/ or pg_multixact/offsets/ are getting larger too
> but by only a few hundreds MBs.

This is consistent with the idea that something is holding back the
oldest-transaction horizon. (However, I'd think you'd also be having
serious problems with table bloat if that were true, so it's a bit
mystifying.) Did you check for unclosed prepared transactions?

select * from pg_prepared_xacts;

regards, tom lane