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. > As a summary, disadvantages are: > ================================== > . Memory issue when read/save/retrieve the file > . Increase load Those can be a consideration, yes. > . Consume connections You will need a connection to the database anyway. There's no need to use another one. > . during transaction lo may be lost? Huh ? > . file systems do better than DB That's not a fact but rather an assertion. And a partial one at that. You may want to search the archives a bit as this has been discussed at length various times. Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql