From: Massimo Ortensi <mortensi@unimaticaspa.it>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: 32 TB size limit almost reached
Date: Mon, 18 Oct 2021 10:59:11 +0200
Message-ID: <1mcOUD-000BPN-3N@unimaticaspa.it> (raw)
In-Reply-To: <ef42dca9-2268-c34b-3717-b994395c92f3@unimaticaspa.it>
References: <1ltQeA-000URA-EE@unimaticaspa.it>
<CAM+6J97VdKJjaU2Uwn_GYThy23q0-29c2hjRrbZZh3_8eO-oJA@mail.gmail.com>
<ef42dca9-2268-c34b-3717-b994395c92f3@unimaticaspa.it>
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 ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mortensi@unimaticaspa.it
Subject: Re: 32 TB size limit almost reached
In-Reply-To: <1mcOUD-000BPN-3N@unimaticaspa.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox