# Serverproperties table is large(postgresql)

**URL:** https://discourse.orthanc-server.org/t/serverproperties-table-is-large-postgresql/5227
**Category:** General
**Created:** [October 7, 2024, 3:29am UTC](https://discourse.orthanc-server.org/t/serverproperties-table-is-large-postgresql/5227 "2024-10-07T03:29:17Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Mars456](https://discourse.orthanc-server.org/letter_avatar_proxy/v4/letter/m/df705f/32.png) [@Mars456](https://discourse.orthanc-server.org/u/Mars456)
#### Post date: [October 7, 2024, 3:29am UTC](https://discourse.orthanc-server.org/t/serverproperties-table-is-large-postgresql/5227/1 "2024-10-07T03:29:17Z")

</div>

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](https://discourse.orthanc-server.org/uploads/default/original/2X/5/507c9f2be0670d44a862da4e11f1b602651d881e.jpeg)  
 ![image](https://discourse.orthanc-server.org/uploads/default/original/2X/c/ccd5e54a08b1fd0ddccdd5e1c864a6f6e270c727.jpeg)

Best regard！

---

<div class="post-metadata">

### Author: ![alainmazy](https://discourse.orthanc-server.org/user_avatar/discourse.orthanc-server.org/alainmazy/32/1576_2.png) [@alainmazy](https://discourse.orthanc-server.org/u/alainmazy)
#### Post date: [October 8, 2024, 7:11am UTC](https://discourse.orthanc-server.org/t/serverproperties-table-is-large-postgresql/5227/2 "2024-10-08T07:11:28Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Mars456](https://discourse.orthanc-server.org/letter_avatar_proxy/v4/letter/m/df705f/32.png) [@Mars456](https://discourse.orthanc-server.org/u/Mars456)
#### Post date: [October 8, 2024, 7:24am UTC](https://discourse.orthanc-server.org/t/serverproperties-table-is-large-postgresql/5227/3 "2024-10-08T07:24:41Z")

</div>

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