PostgreSQL pg_largeobject table still contains deleted objects
Issue
- pg_largeobject table not freed
- Bundles or content appear to be deleted but the Large Object (LOB) entries in
pg_largeobjectare not deleted - pg_largeobject is using too much disk space due to old objects that have been removed being left in the table
Environment
- PostgreSQL 8.4, 9.0, 9.1, 9.2, 9.3
- PostgreSQL client application which uses Binary Large Object (BLOB) data types
- Such as storing files or other binary data in a row of a database table
- Client application removes all references of the BLOB data
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
