New answers tagged vacuum
You should never stop a vacuum process, ever. A vacuum full will completely recreate the table, so it should take roughly as long to run as it would to create and populate a brand new table and index it with all 490_000_000 records.
To answer myself. It was somehow related to https://www.postgresql.org/message-id/flat/111D0E27-A8F3-4A84-A4E0-B0FB703863DF%40s24.com#111D0E27-A8F3-4A84-A4E0-B0FB703863DF@s24.com i think. The OS changed from Debian7 to Debian8, and so the dynamically linked libc6 changed. Had to do a REINDEX on all my Tables with Indexed String Columns.
Top 50 recent answers are included