Re: Large Objects and and Vacuum - Mailing list pgsql-general

From John R Pierce
Subject Re: Large Objects and and Vacuum
Date
Msg-id 4F019263.3090506@hogranch.com
Whole thread Raw
In response to Large Objects and and Vacuum  ("Simon Windsor" <simon.windsor@cornfield.me.uk>)
Responses Re: Large Objects and and Vacuum  ("Simon Windsor" <simon.windsor@cornfield.me.uk>)
List 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 by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Large Objects and and Vacuum
Next
From: Jasen Betts
Date:
Subject: Re: [partition table] python fetchall or fetchone function can not get the returning rows