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-... 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#... Regards, Fritz ______________________________________________________________________________ Το περιεχόμενο αυτού του ηλεκτρονικού μηνύματος και τυχόν συνημμένα αρχεία είναι εμπιστευτικά. Απευθύνεται μόνο στους αναφερόμενους παραλήπτες. Αν λάβατε αυτό το μήνυμα εκ παραδρομής, παρακαλείσθε να επικοινωνήσετε αμέσως με τον αποστολέα του μηνύματος ή τον διαχειριστή του συστήματος και να μην αποκαλύψετε σε κανένα το περιεχόμενο. Οι απόψεις που εκφράζονται ανήκουν στον συγγραφέα και δεν εκφράζουν κατ' ανάγκη τις απόψεις της Παγκρήτιας Συνεταιριστικής Τράπεζας. The contents of this email and any attachments are confidential. It is intended for the named recipients only. If you have received this email in error please notify the system administrator or the sender immediately and do not disclose the contents to anyone. Any views or opinions presented are of the author and not necessarily represent those of Pancretan Cooperative Bank

Hi Renee, Thanks for the taking the time to pop-in. So all in all the filesystem storage engine is better option than the DB? Also can you let me know of the command needed to move from DB to filesystem storage engine? Best, George -----Original Message----- From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Renee B Sent: Monday, November 28, 2016 2:55 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Delete Attachment doesn't clean DB Hello George, Am 28.11.2016 um 13:47 schrieb Dimitrakakis Georgios:

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?

There's a commandline script to move the attachments between the backends.

For example filesystem storage doesn't allow the search within attachments where DB does.

The DB backend lets you search for attachment names, not for content in the attachments. <ad>http://feature-addons.de/otrs/Ticket/TicketAttachments lets you search for attachment names even when you use filesystem backend </ad> Kind regards, Renée -- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs ______________________________________________________________________________ Το περιεχόμενο αυτού του ηλεκτρονικού μηνύματος και τυχόν συνημμένα αρχεία είναι εμπιστευτικά. Απευθύνεται μόνο στους αναφερόμενους παραλήπτες. Αν λάβατε αυτό το μήνυμα εκ παραδρομής, παρακαλείσθε να επικοινωνήσετε αμέσως με τον αποστολέα του μηνύματος ή τον διαχειριστή του συστήματος και να μην αποκαλύψετε σε κανένα το περιεχόμενο. Οι απόψεις που εκφράζονται ανήκουν στον συγγραφέα και δεν εκφράζουν κατ' ανάγκη τις απόψεις της Παγκρήτιας Συνεταιριστικής Τράπεζας. The contents of this email and any attachments are confidential. It is intended for the named recipients only. If you have received this email in error please notify the system administrator or the sender immediately and do not disclose the contents to anyone. Any views or opinions presented are of the author and not necessarily represent those of Pancretan Cooperative Bank

Great! Thank you all for your help and apologies for not answering earlier! Regards, G. -----Original Message----- From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Renee B Sent: Monday, November 28, 2016 3:23 PM To: otrs@lists.otrs.org Subject: Re: [otrs] Delete Attachment doesn't clean DB Hello George, Am 28.11.2016 um 14:15 schrieb Dimitrakakis Georgios:

Hi Renee,

Thanks for the taking the time to pop-in.

So all in all the filesystem storage engine is better option than the DB?

IMHO yes.

Also can you let me know of the command needed to move from DB to filesystem storage engine?

perl bin/otrs.Console.pl Admin::Article::StorageSwitch --target ArticleStorageFS Kind regards, Renée -- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs ______________________________________________________________________________ Το περιεχόμενο αυτού του ηλεκτρονικού μηνύματος και τυχόν συνημμένα αρχεία είναι εμπιστευτικά. Απευθύνεται μόνο στους αναφερόμενους παραλήπτες. Αν λάβατε αυτό το μήνυμα εκ παραδρομής, παρακαλείσθε να επικοινωνήσετε αμέσως με τον αποστολέα του μηνύματος ή τον διαχειριστή του συστήματος και να μην αποκαλύψετε σε κανένα το περιεχόμενο. Οι απόψεις που εκφράζονται ανήκουν στον συγγραφέα και δεν εκφράζουν κατ' ανάγκη τις απόψεις της Παγκρήτιας Συνεταιριστικής Τράπεζας. The contents of this email and any attachments are confidential. It is intended for the named recipients only. If you have received this email in error please notify the system administrator or the sender immediately and do not disclose the contents to anyone. Any views or opinions presented are of the author and not necessarily represent those of Pancretan Cooperative Bank