_M_ARENA_OPTS

[John Barton]

When running Sybase IQ (data warehousing database from Sybase) which runs as a single UNIX processes with a large number of pthreads (1000+) and a large amount of memory (64bit say 16GB+ ) for database cache where all threads need access to the memory. pthreads also allocate heap memory for other tasks and then free memory when done. I seem to recall reading that a pthread can only access memory from a single arena? Would we be better off using a single arena ie (export _M_ARENA_OPTS = 1:4096)? The reason were asking is after running the database for a few weeks we seem to be having memory fragementation issues.

[James A. Donovan]

This may or may not answer you're question.

http://devrsrc1.external.hp.com/STK/impacts/i764.html

If you haven't already, I would open a ticket with Sybase as they are the most likely to be able to provide you with an answer.