Обсуждение: Storing big chunks of text, variable length

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

The Text type in PostgreSQL 7.1 can hold up to 1GB of text and AFAIK
performes quite well.

Previous versions had a text limit of 8-32KB, so upgrade to 7.1, if you
haven't allready.

HTH,
Poul L. Christiansen

Thomas Weholt wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl