Hello Fritz!

Thanks for the info provided.

If I switch to the FileSystem storage for attachment what will happen to the ones already uploaded? Will they be affected?

Furthermore if I understand correctly there are things you gain and things you lose (as always) by using either of the storage engines.

For example filesystem storage doesn’t allow the search within attachments where DB does. On the other hand a huge database might be the cause for delays , is difficult to backup (you need the same amount of storage) etc. Are there any other significant differences??

Best regards,

George

From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Friedrich Kolbel
Sent: Monday, November 28, 2016 2:27 PM
To: otrs@lists.otrs.org
Subject: Re: [otrs] Delete Attachment doesn't clean DB

Am 23.11.2016 um 13:34 schrieb Dimitrakakis Georgios:

Hi all,

I am testing how can I free some space from the DB.

Therefore I have created a ticket with multiple “big” attachments and then went directly to the ticket and I have deleted the attachments.

I was expecting to see a noticeable reduce of the DB size but didn’t see anything.

Any reason why? Is there any other process I should run to cleat it up?

My OTRS version is 5.0.12 with PostgreSQL DB 9.4

Regards,

George

Hi George,

You might need "VACUUM FULL" but you will need some space for that!
see: http://dba.stackexchange.com/questions/37028/vacuum-returning-disk-space-to-operating-system


Maybe you should consider to store all Attachments in the Filesystem instead ob delete Tickets - this will keep the DB very small!

shell> bin/otrs.Console.pl Admin::Article::StorageSwitch --target ArticleStorageFS

see: https://otrs.github.io/doc/manual/admin/5.0/en/html/performance-tuning.html#performance-tuning-otrs-storage

Regards, Fritz