Hello I had that once. Check that your autovacuum is running. And do not allow infinite sessions.
Kind regards,
Christian Mack
Am 14.04.21 um 13:24 schrieb Sarah Harnohs (s...@teamfon.com):
> Hi all,
>
> I have trouble with our postgresql Database in combination with sogo.
> The Database table 'sogo_cache_folder' is growing strongly.
> the partition has not grown in recent years.
>
> But now from 5 GB to 150GB in a few days.
> sogo=# SELECT pg_size_pretty( pg_total_relation_size('sogo_cache_folder') );
> pg_size_pretty
> ----------------
> 156 GB
> (1 row)
>
> How can we identify which datatype and kind is this?
> Kind Regards
> Sarah Harnohs
>
--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
