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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
