PostgreSQL pg_largeobject table still contains deleted objects

Solution Verified - Updated -

Issue

  • pg_largeobject table not freed
  • Bundles or content appear to be deleted but the Large Object (LOB) entries in pg_largeobject are 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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In