Re: Large Objects

Поиск
Список
Период
Сортировка
От Pierre-Frédéric Caillaud
Тема Re: Large Objects
Дата
Msg-id opsj1h922pcq72hf@musicbox
обсуждение исходный текст
Ответ на Re: Large Objects  (Dan Boitnott <dan@mcneese.edu>)
Список pgsql-general
> gives me (and those on high) the warm-fuzzies.  If I store files (PDFs
> of varying sizes by the way, say from 500k to 50M) as large objects,
> will I still be able to restore the _whole_ database from a single
> pg_dump tar file?

    Don't forget a thing :

    If you put a webserver in front of this, you will have to load the entire
object in RAM before you can serve it to the client, which means a little
number of requests on large files will kick the server into swapalot mode.
Using filesystem files solves this in the most easy of ways, but creates
backup problems, but it's not that complex.

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

Предыдущее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: Generating unique values for TEXT columns
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Postgresql website issues.