Storing files in postgres db

From: "tam wei" <twxtam(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Storing files in postgres db
Date: 2006-12-03 16:28:52
Message-ID: f752d55c0612030828p10396841w8ed0f6c564a4145f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the original file alignment can't be preserved) while
extracting the content and display iit using php).

Will it be a bad idea for storing the files in DB? the file size is
about 20 ~ 40 KB. 3K files need to be stored per day. Is there any
impact on the DB performance?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message yt_groups 2006-12-03 16:34:22 Re: CertFirst Legit?
Previous Message Michael Guyver 2006-12-03 13:52:06 Re: Concatenate performance question