Message-ID: <4DD557DA.9040800@encs.concordia.ca>
Date: Thu, 19 May 2011 13:48:10 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.16) Gecko/20101125 Lightning/1.0b1 Thunderbird/3.0.11
MIME-Version: 1.0
To: Craig Ringer <craig@postnewspapers.com.au>
CC: Karsten Hilbert <Karsten.Hilbert@gmx.net>, 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>
	<4DD5295B.7060901@postnewspapers.com.au>
In-Reply-To: <4DD5295B.7060901@postnewspapers.com.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Craig, Karsten,

> 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.

The situation is:
======================
. pdf file size: 500kb
. 65 files per year = 32M
. operation: read/save/remove
   but the total file number is around 65 files per year

How is the above case, saving pdf files into psql8.3 is an acceptable way?

Thank you,
Emi