Craig, Karsten,
> Hardly everyone. You lose transaction safety when using file system
> storage outside the DB, you need another way to talk to the server than
> just the Pg connection, and most importantly your backups become more
> complicated because you have two things to back up.
>
> It's not simple, and it depends a lot on how much the data changes, how
> big the files are, etc.
The situation is:
======================
. pdf file size: 500kb
. 65 files per year = 32M
. operation: read/save/remove but the total file number is around 65 files per year
How is the above case, saving pdf files into psql8.3 is an acceptable way?
Thank you,
Emi