David Wall <d.wall@xxxxxxxxxxxx> writes: > Does the psql command 'vacuum;' by itself automatically vacuum > pg_largeobject along with all of tables in the database? Yes, if it's issued by a superuser or the database owner. However, that won't help much if pg_largeobject has become bloated by a lot of no-longer-wanted BLOBs. After deleting those, you'll probably need VACUUM FULL or CLUSTER or some such if you want to reclaim the disk space. Plain VACUUM usually isn't very successful at shortening a table file. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
