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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
