title: Is it possible to truncate the pg_largeobject table in postgres?
body: <p>I would like to discard the contents of the <strong>pg_largeobject</strong> table and reclaim its disk space. When I try issuing this command:</p>
  
  <pre><code>truncate pg_largeobject
  </code></pre>
  
  <p>I get this response:</p>
  
  <pre><code>ERROR:  permission denied: "pg_largeobject" is a system catalog
  </code></pre>
  
  <p>This is even though I am issuing the command as user <strong>postgres</strong> (a superuser). There is insufficient disk space to do a <strong>VACUUM FULL</strong> while the table contains a lot of rows. I've also tried just deleting all the rows in preparation for a <strong>VACUUM FULL</strong>, but this was still going after a whole day, and ended up being interrupted. I'd prefer to truncate if at all possible.</p>
  
  <p>Is truncation of this table possible? It currently contains around 1 TB of images I no longer want. I've removed references to the table from all my other tables (and deleted all rows from <strong>pg_largeobject_metadata</strong>).</p>