gleeco <gleeco@xxxxxxxxx> writes: > hello - i've a long-running manual vacuum on a big size table. It's many > TB db that has some toast. What is odd is that it keeps looping back on > the same toast / index, eg. It's not looping ... it's filling up your maintenance_work_mem (which is evidently set to 1GB) with dead TIDs and then pausing to do a cycle of index cleaning. You have evidently let that table get, um, severely bloated. Was autovacuum off? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
