为什么真空填满了我的桌子的大小？

Question

我正在用一张无法收缩的肿的桌子挣扎。它只有6行，但大小为140MB+，并且通过快速交易删除了\。我尝试使用真空和真空吸尘器，但没有结果。

这些是表结构和相关统计信息：

\d bloated_table
         COLUMN          |            TYPE             | Collation | Nullable | DEFAULT
-------------------------+-----------------------------+-----------+----------+---------
 col1                    | BIGINT                      |           | NOT NULL |
 <omissis>               | CHARACTER varying(100)      |           |          |
 <omissis>               | CHARACTER varying(50)       |           |          |
 <omissis>               | TIMESTAMP WITHOUT TIME ZONE |           |          |
 <omissis>               | BIGINT                      |           |          |
 <omissis>               | BIGINT                      |           |          |
 <omissis>               | BIGINT                      |           |          |
 <omissis>               | TEXT                        |           |          |
INDEXES:
    "<omissis>" PRIMARY KEY, btree (col1)
Referenced BY:
    TABLE "<omissis>" CONSTRAINT "<omissis>" FOREIGN KEY (col1) REFERENCES <omissis>(col1)

SELECT ROUND(n_dead_tup::NUMERIC/NULLIF(n_live_tup::NUMERIC,0),2), * 
FROM pg_catalog.pg_stat_user_tables 
WHERE n_dead_tup>0 
ORDER BY 1 DESC NULLS LAST
FETCH FIRST ROW ONLY;

   round   |  relid   | schemaname           |          relname           | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_tup_hot_upd | n_live_tup | n_dead_tup | n_mod_since_analyze | n_ins_since_vacuum |          last_vacuum          |        last_autovacuum        |         last_analyze          |       last_autoanalyze        | vacuum_count | autovacuum_count | analyze_count | autoanalyze_count
-----------+----------+----------------------+----------------------------+----------+--------------+----------+---------------+-----------+-----------+-----------+---------------+------------+------------+---------------------+--------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+--------------+------------------+---------------+-------------------
 215689.17 | 59328017 | db_bloated_table     | bloated_table              | 27462255 |    279950918 |      679 |           691 |        20 |  25895488 |        14 |      25476514 |          6 |    1294135 |                   7 |                  0 | 2022-07-06 07:32:24.031073+00 | 2022-07-06 07:39:54.601903+00 | 2022-07-05 22:06:37.492046+00 | 2022-07-06 07:39:54.657717+00 |           30 |            39195 |            26 |             38875

表大小为143MB：

SELECT pg_size_pretty(pg_total_relation_size('bloated_table'::regclass));
 pg_size_pretty
----------------
 143 MB

在这里更新对不起，我严重粘贴了真空输出： 遵循真空输出：

> vacuum (verbose) bloated_table;
INFO:  vacuuming "argodb.bloated_table"
INFO:  "bloated_table": found 0 removable, 25570 nonremovable row versions in 343 out of 343 pages
DETAIL:  25564 dead row versions cannot be removed yet, oldest xmin: 87657915
There were 16 unused item identifiers.
Skipped 0 pages due to buffer pins, 0 frozen pages.
0 pages are entirely empty.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  vacuuming "pg_toast.pg_toast_59328017"
INFO:  "pg_toast_59328017": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages
DETAIL:  0 dead row versions cannot be removed yet, oldest xmin: 87657915
There were 0 unused item identifiers.
Skipped 0 pages due to buffer pins, 0 frozen pages.
0 pages are entirely empty.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
VACUUM

> vacuum (full,verbose) bloated_table;
INFO:  vacuuming "argodb.bloated_table"
INFO:  "bloated_table": found 0 removable, 29068 nonremovable row versions in 389 pages
DETAIL:  29062 dead row versions cannot be removed yet.
CPU: user: 0.03 s, system: 0.01 s, elapsed: 0.06 s.
VACUUM

最后，没有任何长期打开的交易，废弃的复制插槽或孤立准备的交易：

--Abandoned replication slots
>SELECT slot_name, slot_type, DATABASE, xmin
FROM pg_replication_slots
ORDER BY AGE(xmin) DESC;
 slot_name | slot_type | DATABASE | xmin
-----------+-----------+----------+------
(0 ROWS)
 
 
--Orphaned prepared transactions
> SELECT gid, PREPARED, OWNER, DATABASE, TRANSACTION AS xmin
FROM pg_prepared_xacts
ORDER BY AGE(TRANSACTION) DESC;
 gid | PREPARED | OWNER | DATABASE | xmin
-----+----------+-------+----------+------
(0 ROWS)
 

我的环境如下：pg 13.6在MS Azure灵活服务器上，

请感谢您的帮助。