Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id EB48DB5DBC1 for ; Thu, 19 May 2011 11:30:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 82205-10 for ; Thu, 19 May 2011 14:30:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [173.230.139.50]) by mail.postgresql.org (Postfix) with ESMTP id B36E0B5DBBF for ; Thu, 19 May 2011 11:30:11 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id 471774B9; Thu, 19 May 2011 10:30:11 -0400 (EDT) X-Virus-Scanned: amavisd-new at postnewspapers.com.au.com Received: from www.postnewspapers.com.au ([127.0.0.1]) by localhost (www.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id bv+OOkTanPBd; Thu, 19 May 2011 10:30:10 -0400 (EDT) Received: from mail.postnewspapers.com.au (ppp171-128.static.internode.on.net [150.101.171.128]) by www.postnewspapers.com.au (Postfix) with ESMTP id 24B7327; Thu, 19 May 2011 10:30:09 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id C6ECBAF33C; Thu, 19 May 2011 22:30:04 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id CSEiP8MkfvXH; Thu, 19 May 2011 22:29:58 +0800 (WST) Received: from [10.1.1.5] (124-169-254-58.dyn.iinet.net.au [124.169.254.58]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id B2626AF33B; Thu, 19 May 2011 22:29:54 +0800 (WST) Message-ID: <4DD5295B.7060901@postnewspapers.com.au> Date: Thu, 19 May 2011 22:29:47 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110428 Fedora/3.1.10-1.fc14 Thunderbird/3.1.10 MIME-Version: 1.0 To: Karsten Hilbert CC: 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> <4DD47D28.3070207@postnewspapers.com.au> <4DD4B1EB.50202@techbaza.pl> <4DD51DAA.4010706@encs.concordia.ca> <20110519135331.GI2381@hermes.hilbert.loc> In-Reply-To: <20110519135331.GI2381@hermes.hilbert.loc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/118 X-Sequence-Number: 35402 On 05/19/2011 09:53 PM, Karsten Hilbert wrote: > On Thu, May 19, 2011 at 09:39:54AM -0400, Emi Lu wrote: > >> All right, it seems that everyone thinks saving a pdf into postgresql >> is not a good idea. > > No. Hardly everyone. You lose transaction safety when using file system storage outside the DB, you need another way to talk to the server than just the Pg connection, and most importantly your backups become more complicated because you have two things to back up. It's not simple, and it depends a lot on how much the data changes, how big the files are, etc. -- Craig Ringer