Duplicate table schema scap and scap2 in database

Hi,

our database filled up all the space of the server again, so I had another look at the postgres container and saw that there are two table_schemas scap and scap2 with both using approximately the same amount of space.

What is scap2 for? What can I do to get my db smaller again? Vacuuming doesn’t seem to do the trick this time.

Best regards

Chris

@Chartman123 well.

Just

DROP SCHEMA scap2 CASCADE;

and then

VACUUM FULL;

hope this helps :grin:

Eero

1 Like