Storing big chunks of text, variable length

Thomas Weholt <thomas@cintra.no>

From: Thomas Weholt <thomas@cintra.no>
To: pgsql-novice@postgresql.org
Date: 2001-04-24T15:53:52Z
Lists: pgsql-novice
Hi,

What would be the most efficient way, performance wise, of storing alot of 
rather big chunks of text in seperate records in PostgreSQL. I'm dividing 
huge XML-documents into smaller bits and placing the bits into seperate 
records. Requests want all or just some of the records, and the document is 
re-built based on the request. So everything is heavy IO-based.

What would be the best way to do this? LargeObject, the binary blob feature 
of PostgreSQL or .... ????

The chunks can be everything from a few lines to entire documents of 
several megabytes ( ok, that's the extreme example, but still .... )

Best regards,
Thomas