dbhandary@switchfly.com wrote:
> I am including debug trace here. It seems like auto vacuum is running in an
> infinite loop. Will be happy to provide more info if necessary.
>
> (gdb) bt
> #0 0x00007fb9740eb5b3 in __select_nocancel () from /lib64/libc.so.6
> #1 0x000000000075ad7a in pg_usleep ()
> #2 0x00000000004ae2d4 in GetMultiXactIdMembers ()
> #3 0x000000000047f6cc in heap_prepare_freeze_tuple ()
> #4 0x000000000057d036 in lazy_vacuum_rel ()
Can you please provide pg_controldata output?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services