On 05/19/2011 09:53 PM, Karsten Hilbert wrote:
> On Thu, May 19, 2011 at 09:39:54AM -0400, Emi Lu wrote:
>
>> All right, it seems that everyone thinks saving a pdf into postgresql
>> is not a good idea.
>
> No.
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.
--
Craig Ringer