| From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Storing Video's or vedio file in DB. |
| Date: | 2014-12-17 16:52:45 |
| Message-ID: | 20141217175245.bb4733ccf6292a6206be6a73@wanadoo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 17 Dec 2014 13:55:46 +0100
Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
>
> Another downside you didn't mentioned is the fact that you have to distribute the files in the filesystem properly.
> Having thousands or even millions of files in a single directory is not going to be maintenance friendly either.
>
That's not a very hard problem to solve. Just write a script that splits the directory into 1000 file chunks, I did it with perl from scratch in a few hours.
Now my database dumps in seconds, and rsync takes care of new files just as fast.
--
Salutations, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincent Veyron | 2014-12-17 17:03:10 | Re: Storing Video's or vedio file in DB. |
| Previous Message | Albe Laurenz | 2014-12-17 14:20:54 | Re: Storing Video's or vedio file in DB. |