Re: Large tables management question - Mailing list pgsql-general

From mgundlach@comosoft.de (Michael Gundlach)
Subject Re: Large tables management question
Date
Msg-id 19f46a62.0112050641.3fe85590@posting.google.com
Whole thread Raw
In response to Re: Large tables management question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi

we are developing image databases since years ...

    design hint:
      - store the thumbnails in database as a blob
         ! two tables (image and thumbnail) --
           image points to thumbnail!! (not a joke - a good hint)
      - store preview and original outside in filesystem
      - store the path to preview and orig. in the database

     --> these will be fast, solid and usefull!

If it is a realy production system - please use a hardware (!!!) raid system.
  Use 2 80GB ide drives on a hardware mirror - it is cheap and secure.
    Better are 5 73GB scsi drives as raid 5 (hardware) using one as hotspare ...

Michael

pgsql-general by date:

Previous
From: James Thornton
Date:
Subject: Re: update returns 1, but no changes have been made
Next
From: "Thomas T. Thai"
Date:
Subject: sum up rows of BITs