Re: How to store text files in the postgresql?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: How to store text files in the postgresql?
Дата
Msg-id 407d949e0906120707o5c21ee52o7e706e89a3e7448f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to store text files in the postgresql?  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Ответы Re: How to store text files in the postgresql?  (Alan Hodgson <ahodgson@simkin.ca>)
Список pgsql-general
This is a recurring debate and there are pros and cons for both sides.
It usually comes down to whether you need transactional guarantees for
these large objects.

There are also practical concerns. Transfering these large objects
over a single database tcp connection limits the application
performance a lot. And the database is often more heavyweight than you
really want to keep tied up to serve up images.

Also, it makes backups a pain since it's a lot easier to back up a
file system than a database. But that gets back to whether you need
transactional guarantees. The reason it's a pain to back up a database
is precisely because it needs to make those guarantees.

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

Предыдущее
От: "James B. Byrne"
Дата:
Сообщение: Re: search for partial dates
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: How to store text files in the postgresql?