Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DEC3CB5DBE7 for ; Wed, 18 May 2011 18:38:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 09976-02 for ; Wed, 18 May 2011 21:38:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relaygateway01.edpnet.net (relaygateway01.edpnet.net [212.71.1.210]) by mail.postgresql.org (Postfix) with ESMTP id 7D0BAB5D944 for ; Wed, 18 May 2011 18:38:00 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnkHAKo71E1V6sUd/2dsb2JhbACEWZM2jgx4iHCtEZB3hRKBBwSMDpJ6 X-IronPort-AV: E=Sophos;i="4.65,233,1304287200"; d="vcf'?scan'208";a="11962266" Received: from 85.234.197.29.wls.msr02str3.adsl.dyn.edpnet.net (HELO rivendell.lan) ([85.234.197.29]) by relaygateway01.edpnet.net with ESMTP; 18 May 2011 23:37:59 +0200 Message-ID: <4DD43C37.3040404@ulb.ac.be> Date: Wed, 18 May 2011 23:37:59 +0200 From: Julien Cigar User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.9.2.17) Gecko/20110430 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: column type for pdf file References: <4DD42A1C.30202@encs.concordia.ca> <4DD4301F.4010403@ulb.ac.be> <20110518210041.GF2498@hermes.hilbert.loc> <4DD43867.2040709@ulb.ac.be> <20110518212747.GI2498@hermes.hilbert.loc> In-Reply-To: <20110518212747.GI2498@hermes.hilbert.loc> Content-Type: multipart/mixed; boundary="------------070905020608020703080200" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/108 X-Sequence-Number: 35392 This is a multi-part message in MIME format. --------------070905020608020703080200 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 05/18/2011 23:27, Karsten Hilbert wrote: > On Wed, May 18, 2011 at 11:21:43PM +0200, Julien Cigar wrote: > >>>> Unless you've good reasons to do so it's best to store the file on >>>> the file system >>> Why ? >>> >>> If you suggest reasons are needed for storing the PDF in the >>> database I'd like to know the reasons for *not* doing so. >> It increases the load, consume connections, but the biggest drawback >> is probably the memory consumption .. > Thanks. At least now the OP knows some of the reasoning for > not doing so :-) > Yep sorry, I answered a bit too fast :) > Karsten --------------070905020608020703080200 Content-Type: text/x-vcard; charset=utf-8; name="jcigar.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jcigar.vcf" begin:vcard fn:Julien Cigar n:Cigar;Julien org;quoted-printable:Universit=C3=A9 Libre de Bruxelles adr:;;;;;;Belgium email;internet:jcigar@ulb.ac.be tel;cell:+32 (0) 473 30 71 92 x-mozilla-html:FALSE url:http://www.biodiversity.be version:2.1 end:vcard --------------070905020608020703080200--