To many dead rows we need enable vacumm full in some cases when removing edges
We do run vacuum and see that
NOTICE: In start_execute_parallel num statements left 1 to start execute in 1 threads , num_stmts_running 1, num_stmts_failed in this run 0
INFO: finished vacuuming "rog_02.tmp_dyrkbarjord_13_topo_002_178.edge_data": index scans: 1
pages: 0 removed, 301977 remain, 207244 scanned (68.63% of total)
tuples: 207 removed, 7983843 remain, 7954046 are dead but not yet removable
removable cutoff: 1189559933, which was 2662 XIDs old when operation ended
frozen: 0 pages from table (0.00% of total) had 0 tuples frozen
index scan needed: 63354 pages from table (20.98% of total) had 3464260 dead item identifiers removed
index "edge_data_pkey": pages: 15462 in total, 296 newly deleted, 1333 currently deleted, 1037 reusable
index "edge_data_abs_next_left_edge_idx": pages: 15615 in total, 513 newly deleted, 1291 currently deleted, 778 reusable
index "edge_data_abs_next_right_edge_idx": pages: 15551 in total, 380 newly deleted, 1336 currently deleted, 956 reusable
index "edge_gist": pages: 131019 in total, 7702 newly deleted, 46848 currently deleted, 39146 reusable
index "edge_left_face_idx": pages: 32087 in total, 1616 newly deleted, 17017 currently deleted, 15401 reusable
index "edge_right_face_idx": pages: 28217 in total, 5273 newly deleted, 18050 currently deleted, 12777 reusable
index "edge_start_node_idx": pages: 22193 in total, 2118 newly deleted, 3931 currently deleted, 1813 reusable
index "edge_end_node_idx": pages: 22175 in total, 2120 newly deleted, 3934 currently deleted, 1814 reusable
avg read rate: 1.736 MB/s, avg write rate: 0.042 MB/s
buffer usage: 941061 hits, 1324 misses, 32 dirtied
WAL usage: 9 records, 1 full page images, 4418 bytes
system usage: CPU: user: 4.07 s, system: 0.83 s, elapsed: 5.95 s
INFO: vacuuming "rog_02.pg_toast.pg_toast_217408588"
INFO: finished vacuuming "rog_02.pg_toast.pg_toast_217408588": index scans: 0
pages: 0 removed, 28 remain, 28 scanned (100.00% of total)
tuples: 0 removed, 23 remain, 0 are dead but not yet removable
removable cutoff: 1189559933, which was 2662 XIDs old when operation ended
new relminmxid: 2326730934, which is 4678 MXIDs ahead of previous value
frozen: 0 pages from table (0.00% of total) had 0 tuples frozen
index scan not needed: 0 pages from table (0.00% of total) had 0 dead item identifiers removed
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 87 hits, 0 misses, 0 dirtied
WAL usage: 1 records, 0 full page images, 188 bytes
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
INFO: analyzing "tmp_dyrkbarjord_13_topo_002_178.edge_data"
INFO: "edge_data": scanned 300000 of 301977 pages, containing 22382 live rows and 7902620 dead rows; 22382 rows in sample, 22529 estimated total rows
NOTICE: In start_execute_parallel, test if done for stmt (VACUUM (ANALYZE,verbose) tmp_dyrkbarjord_13_topo_002_178.edge_data) on connection conn_9917de7a96fb220e82cac8977bc50e25_1
NOTICE: In start_execute_parallel, Done with stmt (<NULL>) on connection conn_9917de7a96fb220e82cac8977bc50e25_1 and retv <NULL>
Here we 25010 live rows and 3441601 dead rows
INFO: analyzing "tmp_dyrkbarjord_13_topo_002_178.edge_data"
INFO: "edge_data": scanned 300000 of 301977 pages, containing 25010 live rows and 3441601 dead rows; 25010 rows in sample, 25175 estimated total rows
< [local], postgres, rog_02, 2024-11-22 10:16:31.281 CET >LOG: duration: 16450.790 ms statement: VACUUM (ANALYZE,verbose) tmp_dyrkbarjord_13_topo_002_178.edge_data
NOTICE: In start_execute_parallel, test if done for stmt (VACUUM (ANALYZE,verbose) tmp_dyrkbarjord_13_topo_002_178.edge_data) on connection conn_9917de7a96fb220e82cac8977bc50e25_1
NOTICE: In start_execute_parallel, Done with stmt (<NULL>) on connection conn_9917de7a96fb220e82cac8977bc50e25_1 and retv <NULL>
NOTICE: In start_execute_parallel, Started new stmt (VACUUM (ANALYZE,verbose) tmp_dyrkbarjord_13_topo_002_178.face) on connection conn_9917de7a96fb220e82cac8977bc50e25_1 using index 1Lars