RE: PDQ memory / non-PDQ memory

Formally, PDQ memory is not 'reserved' when PDQ is not running. It is accessible to other sessions .... This is theory. In fact, this memory can't be allocated to memory-hungry subsystems, such as buffer cache. If other sessions allocate a lot of memory from the same pool (V segment), then the server needs to allocate another V segment to host PDQ queries - or You should disconnect some sessions to free memory. The best way to think of PDQ memory is that it is reserved for DSS queries and index builds to dramatically improve query performance 'on demand' ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: emebohw@netscape.net [mailto:emebohw@netscape.net] > > This is likely obvious, so feel free to treat me like a know-nothing > bimbo. If I dedicate X amount of memory to informix and set Y > available to PDQ - is Y amount available to non-PDQ processes when not > in use? Or is it always reserved and sitting around doing nothing when > I am not using PDQ for anything? I also ask the same question from the > other direction...if PDQ is humming and theres not a lot of other > activity going on, can PDQ use X memory or is Y its absolute ceiling > no matter what? sending to informix-list