Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BDB429FB905 for ; Wed, 4 Apr 2007 11:04:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 72540-02 for ; Wed, 4 Apr 2007 11:03:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id CB72F9FB53A for ; Wed, 4 Apr 2007 11:03:50 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so245114ana for ; Wed, 04 Apr 2007 07:03:49 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=OhIb8C9RHVU9RgBleNT3LFKwaAVlPS+8W8Kuc2HddYRVU13kJPDKinfgqIywoHP+C0hNDcOHET65TIJ+EvzJ69DtwAbvtOQX9RQM3zOKaZuHmcfSbrWdMIv6QzPZsca/wmurUsQObHD0i1p6saLdyUiSXme/EDMWxQmWUs3Mg/4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=kOTfFg9COOb49+8TK6R4UIRjDNhRcPbYnLwATmwnbaqtaA4kEi4LgD241bHjtUGJQkx2YOgOtjI+mM0RIrIZ6zv8RtONn6jgcHN7d9BfXddFlHK0it3dbL5ugYjCqAQ2NbWetLYCMlyrnaoywcUQo9CVRx7CCF7ce9dwsOgFyrg= Received: by 10.100.196.3 with SMTP id t3mr407918anf.1175695429100; Wed, 04 Apr 2007 07:03:49 -0700 (PDT) Received: by 10.100.135.15 with HTTP; Wed, 4 Apr 2007 07:03:49 -0700 (PDT) Message-ID: <26551fb50704040703n75d9b8d9p7ab4bf11109dfe63@mail.gmail.com> Date: Wed, 4 Apr 2007 11:03:49 -0300 From: "Alexandre Vasconcelos" To: pgsql-performance@postgresql.org Subject: Large objetcs performance MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/67 X-Sequence-Number: 23944 Hello All, I've been searching the archives for something similar, without success.. 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. Thanks in advace. Alex