From: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
---|---|
To: | Kris Kewley <kris(dot)kewley(at)gmail(dot)com> |
Cc: | "rterry(at)pacific(dot)net(dot)au" <rterry(at)pacific(dot)net(dot)au>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: bytea and text |
Date: | 2009-11-29 14:30:57 |
Message-ID: | 4B1285A1.6060207@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Kris Kewley a écrit :
> Some interesting points were made. Depending on the roadmap for you
> application consideration should be given to storing the image files
> outside of the db.
>
> IMO the driving factors here are:
> 1. Scalability
> 2. Version control of images
> 3. Backup
> 4. Performance
>
> Including images in your db will accerlate it's growth. You noted legal
> concerns, version control is typically an important aspect of this. Back
> up and restore time will increase as db size is larger, and will be more
> costly (assume db on more expensive disk than file server). Finally
> performance.. Blobs typically increase disk io on queries (at least they
> do in oracle) so should be used judicially in heavily accessed tables.
These tables are not heavily accessed: they're linked to heavily accessed
other tables.
They only contains an id, a RI, a pic_nb and a bytea.
Pictures are practically never upgraded and jettisoned when obsolete.
> Realize that I have made some wild assumptions about your app here, but
> this is my experience.
>
> Consider a link in your db and using cvs for storing the images, or
> filesystem depending on the extent of to your needs.
NO, I want only one backup solution, not one for each case; and perfs are
only needed for other tables.
> I too stand to be corrected :-)
I see, you're doing BDSM :D
JY
--
Leave no stone unturned.
-- Euripides
From | Date | Subject | |
---|---|---|---|
Next Message | Rikard Bosnjakovic | 2009-11-30 09:32:18 | Question when to use BEGIN / END |
Previous Message | Kris Kewley | 2009-11-29 13:41:58 | Re: bytea and text |