Re: scalablility problem - Mailing list pgsql-performance

From Tom Lane
Subject Re: scalablility problem
Date
Msg-id 23586.1175289138@sss.pgh.pa.us
Whole thread Raw
In response to scalablility problem  (Xiaoning Ding <dingxn@cse.ohio-state.edu>)
Responses Re: scalablility problem  (Xiaoning Ding <dingxn@cse.ohio-state.edu>)
List pgsql-performance
Xiaoning Ding <dingxn@cse.ohio-state.edu> 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

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: scalablility problem
Next
From: Xiaoning Ding
Date:
Subject: Re: scalablility problem