| From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: column type for pdf file |
| Date: | 2011-05-19 17:48:10 |
| Message-ID: | 4DD557DA.9040800@encs.concordia.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Craig, Karsten,
> Hardly everyone. You lose transaction safety when using file system
> storage outside the DB, you need another way to talk to the server than
> just the Pg connection, and most importantly your backups become more
> complicated because you have two things to back up.
>
> It's not simple, and it depends a lot on how much the data changes, how
> big the files are, etc.
The situation is:
======================
. pdf file size: 500kb
. 65 files per year = 32M
. operation: read/save/remove
but the total file number is around 65 files per year
How is the above case, saving pdf files into psql8.3 is an acceptable way?
Thank you,
Emi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl Koster | 2011-05-20 19:13:27 | unnest in SELECT |
| Previous Message | Craig Ringer | 2011-05-19 14:29:47 | Re: column type for pdf file |