Veda files clogging up system

[clenox]

When I go to look at results a number of files are created in the pgsql/data/base/16385 folder that take up a huge amount of space.  I have attached a screen shot.  This folder was up to 144GB of storage.  What are these files and can they be deleted?

[AKanudia]

Look at the menu item Model >> Manage disk space >> Database

If you see a similar size reported as "Total Db size" at the bottom of summary tab, then you just need to delete some old cases and/or models, which you can see on other tabs.

Please update this post in either case.

[clenox]

Look at the menu item Model >> Manage disk space >> Database

If you see a similar size reported as "Total Db size" at the bottom of summary tab, then you just need to delete some old cases and/or models, which you can see on other tabs.

Please update this post in either case.

[clenox]

Yes, it is a similar size.  The problem, though, is that every time I create a table to look at, it is adding files and increasing the size.  Once I have looked at the table and exported it, I don't need it saved anymore but I don't know which files to delete.  And crazy stuff is happening.  Yesterday I had 24GB of space left on my computer.  I created and exported about 16 tables with 8 scenarios worth of results and the space on my computer dropped to 14GB.  Then I tried to create a few more tables and Veda hung up and my space was all used up.  Nothing else was done with the computer, so I somehow lost 24GB of space creating a few tables.  And all of that space is taken up by these files in the folder that I shared.

[AKanudia]

Let's see this over a web meeting Carol. Basically, when you work with a database like PostgreSQL, you will need more free space on your machine. We can see how you can manage, but under no circumstances should you consider directly deleting files inside the Veda application folders.

[Antti-L]

Dear Amit,

As there have been several reports of increasing and seemingly wasteful disk space usage of the VEDA PostgreSQL database, would it be possible to put a manual option for doing a full database Vacuum under VEDA, i.e. garbage-collection?  Like under the old VEDA we had the Compact and Repair databases.  I have understood that only the VACUUM FULL command will free up disk space, while the standard vacuum operation will not return the space to the operating system. So, I would like to have the option for doing a manual VACUUM FULL.