Re[2]: Blob question -(((

Hello Brett,

Monday, January 01, 2001, 9:09:10 AM, you wrote:

BWM> On Mon, 1 Jan 2001, Boris wrote:

>> Here are my questions:
>>
>> * Are they any limits to the OID Datatype? I need 50-100k per row.

BWM> 50-100k COLUMNs per row?  Or are you talking about binary files of
BWM> 50-100K?  You definitely need to use the large object fetaures of
BWM> PostgreSQL.

Yes I need approx 50-100k to store ascii data for later
fulltext-search -((

It looks like as if there is a 8kb limit that can be extended to 32k
per row in src/config.h

But it´s still not enough -((

>> * Can I do fulltext-search with OID fields (VERY IMPORTANT QUESTION!!!!)?

BWM> OIDs are just numbers.  If you are using them for large objects, they are
BWM> just 'pointers' to the binary data of a file maintained by the operating
BWM> system.  If you need to search, you should design your database with

Ahhh interesting to know.

BWM> apprpriate description or keyword fields.

Hmm, nice idea, but there are some more columns with TEXT datatype
storing additional text, too. I can not decentralize all the documents
of all fields - or better said I am not sure.

The 8/32kb limit is not very well -(((

I need 50-100kb per row.  -(((

--
Boris
http://www.x-itec.de