dostats, PDQ and the sorting memory usage

Hi all! We are running 9.30.UC3 on Solaris 5.8. We are trying dostats (Features Version 5.10, Source Revision: 1.128 !) and have a couple of misunderstanding. First, we are getting different results (10% difference !) with "-Q 100" option and with PDQPRIORITY=HIGH environment variable. The work was done faster without PDQPRIORITY. Command line - dostats -d is_back -S -Q 100 -v2 -X -e Second, we couldn't use more than 50Mb memory for sorting: dostats -d is_back -S -Q 100 -v2 -X -e -t event UPDATE STATISTICS:================== Table: bp.event Mode: HIGH Number of Bins: 267 Bin size 11757 Sort data 204.4 MB PDQ memory granted 214.6 MB Estimated number of table scans 1 PASS #1 oper_code,currency,event_code,id_document,id_authorization,id_transaction id_card,id_account_credit,id_eod,id_account_debit,id Light scans enabled Scan 20 Sort 8 Build 21 Insert 0 Close 0 Total 49 Completed pass 1 in 0 minutes 49 seconds but dostats -d is_back -S -Q 100 -v2 -X -e UPDATE STATISTICS:================== Table: bp.event Mode: HIGH Number of Bins: 267 Bin size 11757 Sort data 204.4 MB Sort memory granted 50.0 MB Estimated number of table scans 5 PASS #1 oper_code,id_card PASS #2 event_code,id_account_credit,currency PASS #3 id_document,id_eod PASS #4 id_authorization,id_account_debit PASS #5 id_transaction,id Light scans enabled Scan 7 Sort 2 Build 4 Insert 0 Close 0 Total 13 Completed pass 1 in 0 minutes 13 seconds Scan 6 Sort 0 Build 7 Insert 0 Close 0 Total 13 Completed pass 2 in 0 minutes 13 seconds Scan 4 Sort 1 Build 3 Insert 0 Close 0 Total 8 Completed pass 3 in 0 minutes 8 seconds Scan 5 Sort 3 Build 4 Insert 0 Close 0 Total 12 Completed pass 4 in 0 minutes 12 seconds Scan 4 Sort 5 Build 4 Insert 0 Close 0 Total 13 Completed pass 5 in 0 minutes 13 seconds Any ideas would be helpful. Jack Miller --------------------------------- Get your own web address. Have a HUGE year through Yahoo! Small Business.