Abnormal growing Database..

[minzak]

Hi All.

Sometimes, at least once per month, I have a lot of notifications that GraphQL Postrgee DB is abnormally growing.
Also before a normal procedure war runs VACUUM, and the last time it ran for several seconds.
and the last message was:

INFO:  vacuuming "public.Asset"
INFO:  scanned index "Asset_pkey" to remove 1535028 row versions
DETAIL:  CPU: user: 0.80 s, system: 0.40 s, elapsed: 5.06 s
INFO:  "Asset": removed 1535028 row versions in 101673 pages
DETAIL:  CPU: user: 0.25 s, system: 0.66 s, elapsed: 4.89 s
INFO:  index "Asset_pkey" now contains 8377182 row versions in 103703 pages
DETAIL:  20356 index row versions were removed.
4060 index pages have been deleted, 4060 are currently reusable.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
INFO:  "Asset": found 5269 removable, 278135 nonremovable row versions in 106038 out of 311001 pages
DETAIL:  6342 dead row versions cannot be removed yet, oldest xmin: 235208482
There were 3280454 unused item pointers.
Skipped 0 pages due to buffer pins, 203927 frozen pages.
0 pages are entirely empty.
CPU: user: 1.17 s, system: 1.21 s, elapsed: 11.16 s.

And now today I have a big size DB:

root@ada-relay1 /mnt/data/graphql # sudo du -sh postgres-data/
773G	postgres-data/

Why is it always extra growing and what size of your DB?
How to fix it, I mean VACUUM it not helps.

[minzak]

Also need this link here #828 and #808