32 TB size limit almost reached

From: Massimo Ortensi <mortensi(at)unimaticaspa(dot)it>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: 32 TB size limit almost reached
Date: 2021-10-18 08:59:11
Message-ID: 1mcOUD-000BPN-3N@unimaticaspa.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everybody.

I've got a large db, where the pg_largeobject almost reached (or maybe
already reached before vacuum_lo) the 32 TB size limit.

If I query

select pg_table_size ('pg_largeobject')                       35194084753408

select pg_total_relation_size ('pg_largeobject')             35692575506432

select pg_relation_size ('pg_largeobject')                     
35184358776832

I'm still running vacuum_lo and then vacuum -F

How can I tell how near to the limit my db really is ?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Zahid Rahman 2021-10-18 17:04:46 database on selected disk
Previous Message Sébastien Boutté 2021-10-15 10:20:36 Re: Index Corrupted ?