=?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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
