Re: 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

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs