Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

BTS config and space estimates questions

  • 1.  BTS config and space estimates questions

    Posted Thu October 01, 2020 11:37 AM
    Hi all, our developers plan to implement fulltext functionality using BTS in the application and I have a couple of questions and I did not find the answers in docs:
    Sizing of sbspaces
    - is there any estimate formula or rule of thumbs on bts_index size?
    - is there any estimate formula or rule of thumbs on temporary space needed for bts_index creation
    Memory requirements
    - on what depends virtual memory needed for fulltext query (size of result set, size of index etc), is Bufferpool used for bts_indexes - which size? (standard ie 4kb on aix)
    Concurrency and locking
    - can 1 bts vp run more than 1 bts query concurrently?
    - what is an cost of insert/delete/update of a row with bts column? the whole index must be rewritten or just a part?
    PDQ
    - can PDQ help bts index creation? or PSORT_NPROCS
    Thanks a lot for any tip

    ------------------------------
    Milan Rafaj
    ------------------------------

    #Informix


Related Content