Sample Header Ad - 728x90

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