Re: scalablility problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Xiaoning Ding <dingxn(at)cse(dot)ohio-state(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: scalablility problem
Date: 2007-03-30 21:12:18
Message-ID: 23586.1175289138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Xiaoning Ding <dingxn(at)cse(dot)ohio-state(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Xiaoning Ding 2007-03-30 21:38:57 Re: scalablility problem
Previous Message Dave Dutcher 2007-03-30 20:56:17 Re: scalablility problem