Tom, thank you for your answer.
Today I run vacuum full again and my table size dramatically reduced:
postgres@srv-pgsql1:~$ vacuumdb -fvt pg_largeobject mybase
...
INFO: vacuuming "pg_catalog.pg_largeobject"
INFO: "pg_largeobject": found 0 removable, 624465 nonremovable row
versions in 2386876 pages
DETAILS: 586358 dead row versions cannot be removed yet.
mybase=# SELECT pg_size_pretty(pg_total_relation_size('pg_largeobject'));
pg_size_pretty
----------------
1568 MB
My problem is resolved.
20.07.2017 21:50, Tom Lane пишет:
=?UTF-8?B?0K/QvdGH0LXQvdC60L4g0JLQu9Cw0LTQuNC80LjRgA==?= <vyanchenko@xxxxxxxxx> writes:
I found that my pg_largeobject table is bigger than it should be:
Sounds like a fairly routine case of table bloat.
Before I execute queries, that i mentioned above, I run vacuum full. But
it does not effect. Now table bloating factor about 20%.
"vacuum verbose pg_largeobject" might be informative. If, as I suspect,
it tells you there are lots of dead but unremovable rows, look around for
long-lived open transactions or prepared transactions.
regards, tom lane
--
Best regards,
Vladimir Yanchenko
Tech support engineer
Naumen
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
