Re: using Postgres to store many small files

Поиск
Список
Период
Сортировка
От Bas Scheffers
Тема Re: using Postgres to store many small files
Дата
Msg-id 9981.212.124.229.3.1078402326.squirrel@io.scheffers.net
обсуждение исходный текст
Ответ на using Postgres to store many small files  (Matthew Hixson <hixson@poindextrose.org>)
Список pgsql-general
I am assuming these are mugshots displayed on web pages? Put them in
Postgres by all means, I would, but push them out to the file system as
well so the webserver can return them directly, saving database access CPU
cycles. Intercept 404s with a jsp that checks if it was an image being
asked for. If it was and it can find it in the DB, push it out to the
client and write it to disk for the next time. Or run a nightly script
that checks for missing files.

Bas.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Gellert, Andre"
Дата:
Сообщение: Re: Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?
Следующее
От: mbc@soliton.com
Дата:
Сообщение: clarification of postgres limitations