Hi, Craig Ringer wrote:
Brent Wood wrote:
...
I need to store an image in postgresql database and after that i need to retrive the image back.Can you please help me how to do this?
...
- Storing image data in the DB is probably much less efficient in storage space and for access; and - You face possible MVCC bloat with image data when storing in the DB, so careful management would be needed
The first really cool MS-SQL feature I've heard about relates to this. NTFS now has transaction support. I'm pretty sure I remember hearing
*snip* In that case, would that MVCC bloat not just transferred to the filesystem? Large objects should currently give you pretty much the same results without plug for MS-SQL :-) And in most cases bytea as mentioned elsewhere are not so bad either (especially for p*m-Images :-) Cheers Tino
smime.p7s
Description: S/MIME Cryptographic Signature
