Re: Large Objects and and Vacuum

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Large Objects and and Vacuum
Дата
Msg-id 4F019263.3090506@hogranch.com
обсуждение исходный текст
Ответ на Large Objects and and Vacuum  ("Simon Windsor" <simon.windsor@cornfield.me.uk>)
Ответы Re: Large Objects and and Vacuum  ("Simon Windsor" <simon.windsor@cornfield.me.uk>)
Список pgsql-general
On 12/30/11 3:54 PM, Simon Windsor wrote:
> I am struggling with the volume and number of XML files a new
> application is storing.

how big are these XML files?  large_object was meant for storing very
large files, like videos, etc. multi-megabyte to gigabytes.   XML stuff
is typically a lot smaller than that.

me, I would be decomposing the XML in my application and storing the
data in proper relational tables, and only generate XML output if I
absolutely had to send it to another system beyond my control as its
easily one of the most inefficient methods of data representation out there.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Large Objects and and Vacuum
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: [partition table] python fetchall or fetchone function can not get the returning rows