From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | tam wei <twxtam(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Storing files in postgres db |
Date: | 2006-12-04 10:42:36 |
Message-ID: | 4573FB9C.30204@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
tam wei wrote:
> 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).
Hmm - not sure what you mean here. You should just get back whatever you
store.
> 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?
This shouldn't be any different from storing a similar number of text
records.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Tshimanga Minkoka | 2006-12-04 11:59:00 | Re: DBI module for postgres 1.4.3 |
Previous Message | Richard Huxton | 2006-12-04 10:41:16 | Re: Locking for function creation |