Storing files in postgres db

Поиск
Список
Период
Сортировка
Искать
От
tam wei
Тема
Storing files in postgres db
Дата
Msg-id
f752d55c0612030828p10396841w8ed0f6c564a4145f@mail.gmail.com
Список
Дерево обсуждения
Storing files in postgres db "tam wei" <twxtam@gmail.com>
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>
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 по дате отправления
От: Michael Guyver
Дата:
От: Mark Morgan Lloyd
Дата:
Сообщение: Locking for function creation
FAQ