Re: Large objetcs performance

From: Guido Neitzer <lists(at)event-s(dot)net>
To: Alexandre Vasconcelos <alex(dot)vasconcelos(at)gmail(dot)com>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Large objetcs performance
Date: 2007-04-04 14:11:27
Message-ID: 2252379A-2C12-47C0-A22A-635BD21E4E27@event-s.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message jason@ohloh.net 2007-04-04 14:12:20 Re: SCSI vs SATA
Previous Message Alexandre Vasconcelos 2007-04-04 14:03:49 Large objetcs performance