Skip site navigation (1) Skip section navigation (2)

Storing big chunks of text, variable length

From: Thomas Weholt <thomas(at)cintra(dot)no>
To: pgsql-novice(at)postgresql(dot)org
Subject: Storing big chunks of text, variable length
Date: 2001-04-24 15:53:52
Message-ID: 5.0.0.25.0.20010424174926.02643728@mail.cintra.no (view raw or flat)
Thread:
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


Responses

pgsql-novice by date

Next:From: Poul L. ChristiansenDate: 2001-04-24 16:07:48
Subject: Re: Storing big chunks of text, variable length
Previous:From: Joel BurtonDate: 2001-04-24 13:33:48
Subject: Re: Re: BETWEEN clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group