Storing files in postgres db - Mailing list pgsql-general

From tam wei
Subject Storing files in postgres db
Date
Msg-id f752d55c0612030828p10396841w8ed0f6c564a4145f@mail.gmail.com
Whole thread Raw
Responses Re: Storing files in postgres db  (Richard Huxton <dev@archonet.com>)
Re: Storing files in postgres db  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
List 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

pgsql-general by date:

Previous
From: "Michael Guyver"
Date:
Subject: Re: Concatenate performance question
Next
From: Mark Morgan Lloyd
Date:
Subject: Locking for function creation