Re: Large Objects and and Vacuum

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