I have a table with about 4M rows, but each row has some binary data that may consume up to 1Mb.
The autovacuum process on this table is taking over 1.5 hours to complete, which seems way to long to me.
I understand that when Postgres updates or deletes a row it keeps a copy of the old row and then autovacuum cleans this up later.
If my rows have a lot of binary data and they are getting updated regularly, is this the cause of my very slow autovacuum? And is it trying to load all of that data into memory?