I am trying to understand a little better how big things will be getting, or where you'll need the most space on a linux (debian/ubuntu) system.
I guess the most storage hungry components might be pictures or other attachments to any product. I have no idea how a database works, so can anybody explain the principle? Are these kind of files actually inside one big database file or are they separated and only linked to entrie's in the database? As far as I know the database is in /var, correct? So, do I need to be /var on a partition with much space?
Attachments are storing in field of datatype "bytea". Attachments are converting into "binary string" and that sting store into field.
If file size is big, length of string will be also big and it will take more size of disk. It may possible to increase size in case allocation size of disk will full.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/21/13, 9:51 PM|
|Seen: 2350 times|
|Last updated: 3/16/15, 8:10 AM|