Re: Large objetcs performance - Mailing list pgsql-performance

From Guido Neitzer
Subject Re: Large objetcs performance
Date
Msg-id 2252379A-2C12-47C0-A22A-635BD21E4E27@event-s.net
Whole thread Raw
In response to Large objetcs performance  ("Alexandre Vasconcelos" <alex.vasconcelos@gmail.com>)
List pgsql-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

pgsql-performance by date:

Previous
From: "Alexandre Vasconcelos"
Date:
Subject: Large objetcs performance
Next
From: "jason@ohloh.net"
Date:
Subject: Re: SCSI vs SATA