images in one or more tables?

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: images in one or more tables?
Date: 2011-06-12 19:34:27
Message-ID: 20110612213427.1271fa9d@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

[Don't feed the troll: images *will stay* in table(s)]

I've need to store many images (BYTEA): items pictures, items datasheets PDFs
and documents PDFs (suppliers & clients.)

The logical way would be to stuff only one table with these images, however
wouldn't it be faster (in regard to long term accumulation) to have several
images tables (picture, datasheet, supdoc & clidoc) instead?

JY
--

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2011-06-12 20:24:39 Re: images in one or more tables?
Previous Message Jean-Yves F. Barbier 2011-06-12 05:05:12 how to recover a domain types and constraints?