Re: column type for pdf file - Mailing list pgsql-sql

From Emi Lu
Subject Re: column type for pdf file
Date
Msg-id 4DD557DA.9040800@encs.concordia.ca
Whole thread Raw
In response to Re: column type for pdf file  (Craig Ringer <craig@postnewspapers.com.au>)
List 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


pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: column type for pdf file
Next
From: Karl Koster
Date:
Subject: unnest in SELECT