Xiaoning Ding <dingxn@xxxxxxxxxxxxxxxxxx> writes: > When I run multiple TPC-H queries (DBT3) on postgresql, I found the system > is not scalable. My machine has 8GB memory, and 4 Xeon Dual Core processor > ( 8 cores in total). OS kernel is linux 2.6.9. Postgresql is 7.3.18. If you are not running PG 8.1 or later, it's really not worth your time to test this. Multiprocessor scalability was hardly even on the radar in 7.3 days. regards, tom lane