Serverproperties table is large(postgresql)

General
1

Hi, today I found that postgresql runs and prompts no space left. After checking the postgresql file shelf, I found that the serverproperties data table occupies a very large area, reaching 13T. However, there are only four pieces of data when viewing it. The main reason is that toast_size is extremely large.

image
image1566×853 127 KB

image
image988×465 54 KB

Best regard！

2

Hi,

I’m not really familiar with TOAST but, if you have been saving large Jobs registry in the DB, this might have consume TOAST “space”.

It seems that a VACUUM FULL on your table should fix this no ?

HTH,

Alain

3

yes, yesterday I solved this problem by VACUUM FULL on this table. Thank you for your reply.