Re: Large objetcs performance

On 04.04.2007, at 08:03, Alexandre Vasconcelos wrote:

> We have an application subjected do sign documents and store them
> somewhere. The files size may vary from Kb to Mb. Delelopers are
> arguing about the reasons to store files direcly on operating system
> file system or on the database, as large objects. My boss is
> considering file system storing, because he is concerned about
> integrity, backup/restore corruptions. I'd like to know some reasons
> to convince them to store these files on PosgtreSQL, including
> integrity, and of course, performance. I would like to know the file
> system storing disadvantages as well.

It is not directly PostgreSQL related, but this might give you
something to think about:

http://en.wikibooks.org/wiki/Programming:WebObjects/Web_Applications/
Development/Database_vs_Filesystem

cug