Can I do VACUUM FULL to pg_largeobject table?
13
votes
1
answer
21902
views
I have two tables (
table1
, table2
) in a Postgres 9.1 database. Both having oid type. Each table 1 million records. And pg_largeobject
table size is around 40GB. I have removed 0.9 million records from each table, and executed the below command.
vacuum full analyze table1;
vacuum full analyze table2;
Still no change in pg_largeobject
table size (auto vacuum is enabled)
Do I need to execute above command to pg_largeobject
table too? Will it impact anything?
Asked by RBB
(815 rep)
Aug 29, 2015, 08:53 PM
Last activity: Aug 27, 2024, 09:40 PM
Last activity: Aug 27, 2024, 09:40 PM