storage of PS doc as file or large object or text

From: stony8(at)gmx(dot)de (Alexander Steinert)
To: pgsql-general(at)postgresql(dot)org
Subject: storage of PS doc as file or large object or text
Date: 2001-09-27 15:19:04
Message-ID: e536801e.0109270719.4f071e7d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Based on Debian GNU/Linux, PostgreSQL, Apache and Python I'm building
a web app. with PS/PDF documents as data. Their sizes will vary
between a few KB and many MB.

The docs will be printed via CUPS, scanned via SANE and fetched via
HTTP or FTP. Additionally their pages will be displayed inside the
client browsers in order to change their order, delete or insert
single pages. A future use case *might* be that the docs are
downloadable.

The question is wether I should store a doc as a file inside the file
system, as a postgres large object or as a text field inside a
postgres table.

The file approach is simple (KISS!) and employment of command line
tools like psselect would be very easy. OTOH data consistancy is an
important point, since the document maintainers will work in parallel.

Since scalability is also an issue: Is it possible to distribute one
single postgres table across multiple HD partitions?

I would appreciate to see your recommendations or further points I
should consider.

What about Performance and Backup/Restore issues?

TIA

Stony

Browse pgsql-general by date

  From Date Subject
Next Message Randal L. Schwartz 2001-09-27 15:30:57 Re: showing also value '0' with aggregate count()
Previous Message David Christian 2001-09-27 15:18:19 Re: showing also value '0' with aggregate count()