Thanks guys,
I update PG to 8.2.3. The results are much better now.
1 process : 0.94 second
2 processes: 1.32 seconds
4 processes: 2.03 seconds
8 processes: 2.54 seconds
Do you think they are good enough?
BTW where can I found some info on what 8.2.3 did to improve
scalability compared with pre 8.1 versions?
Xiaoning
Tom Lane wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
