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