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-boun...@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
______________________________________________________________________________
Το περιεχόμενο αυτού του ηλεκτρονικού μηνύματος και τυχόν συνημμένα αρχεία
είναι εμπιστευτικά. Απευθύνεται μόνο στους αναφερόμενους παραλήπτες. Αν λάβατε
αυτό το μήνυμα εκ παραδρομής, παρακαλείσθε να επικοινωνήσετε αμέσως με τον
αποστολέα του μηνύματος ή τον διαχειριστή του συστήματος και να μην αποκαλύψετε
σε κανένα το περιεχόμενο. Οι απόψεις που εκφράζονται ανήκουν στον συγγραφέα και
δεν εκφράζουν κατ' ανάγκη τις απόψεις της Παγκρήτιας Συνεταιριστικής Τράπεζας.
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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
