| From: | mgundlach(at)comosoft(dot)de (Michael Gundlach) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Large tables management question |
| Date: | 2001-12-05 14:41:08 |
| Message-ID: | 19f46a62.0112050641.3fe85590@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Rose | 2001-12-05 15:08:50 | lost system tables: any hope? |
| Previous Message | Jeff Boes | 2001-12-05 14:15:45 | Are there theoretical performance "elbows" in tables with many records? |