From: Piotr Czekalski <pczekalski@techbaza.pl>
To: pgsql-sql@postgresql.org
Subject: Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?
Date: Sat, 28 May 2011 09:58:29 +0200
Message-ID: <4DE0AB25.5020109@techbaza.pl> (raw)
In-Reply-To: <BANLkTi=safG7dp3U3LGQPc95j6Yh75KmHQ@mail.gmail.com>
References: <482E80323A35A54498B8B70FF2B87980049413B5EB@azsmsx504.amr.corp.intel.com>
<482E80323A35A54498B8B70FF2B87980049413B673@azsmsx504.amr.corp.intel.com>
<4DDEC3B1.2050008@boscorama.com>
<irna9r$dso$3@reversiblemaps.ath.cx>
<4DDFCD7A.8030902@encs.concordia.ca>
<4DDFCE04.2050402@encs.concordia.ca>
<BANLkTi=safG7dp3U3LGQPc95j6Yh75KmHQ@mail.gmail.com>
Hello Emi Lu,
The detailed discussion was just about two weeks ago on the plpgsql
list, worth of glance.
Actually it is quite difficult to say which one is better in your case
as it depends on utility (rapid file hostin or just storing but
transaction safety is important, etc.).
Generally it seems that your requirements are rather small.
So briefly, my point of view on it:
(1) Pro:
- easy to implement,
- more efficient when storing and retrieving files than other solutions
- easy hosting over dedicated file server (with caching i.e.)
- DB size is small, files are separated - important on shared hosting
where DB size limit is usually much smaller than file storage limit.
Cons:
- nontransactional - actually you may try to create double commit but it
still may fail as it is not "atomic" operation, on two (FS and DB)
- more complicated to backup and restore.
(2) no opinion on mine
(3)
Pro:
- consistent,
- smart solution ;-)
- easy to backup / restore
- transactional
Cons:
- harder to implement storing and retrieving files
- may be non efficient (usually requires app side caching)
- DB size is bigger
Regards,
P.
--
--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB& eCommerce
tel. (+4832) 7186081
fax. (+4832) 7003289
email: biuro@techbaza.pl
web: http://www.techbaza.pl
web: partner.techbaza.pl
web: ekspert.techbaza.pl
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pczekalski@techbaza.pl
Subject: Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?
In-Reply-To: <4DE0AB25.5020109@techbaza.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox