Re: scalablility problem

From: Tom Lane
Subject: Re: scalablility problem
Date: ,
Msg-id: 23586.1175289138@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: scalablility problem  (Xiaoning Ding <-state.edu>)
Responses: Re: scalablility problem  (Xiaoning Ding <-state.edu>)
List: pgsql-performance

Tree view

scalablility problem  (Xiaoning Ding <-state.edu>, )
 Re: scalablility problem  ("Dave Dutcher", )
 Re: scalablility problem  (Tom Lane, )
  Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
   Re: scalablility problem  (Scott Marlowe, )
   Re: scalablility problem  (Ron Mayer, )
    Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
     Re: scalablility problem  (Dave Cramer, )
 Re: scalablility problem  (Scott Marlowe, )
  Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
   Re: scalablility problem  ("Joshua D. Drake", )
    Re: scalablility problem  (Tom Lane, )
     Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
 Re: scalablility problem  (Christopher Browne, )
  Re: scalablility problem  (Guido Neitzer, )
   Re: scalablility problem  (Michael Stone, )
    Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
  Re: scalablility problem  (Xiaoning Ding <-state.edu>, )

Xiaoning Ding <-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:

From: Christopher Browne
Date:
Subject: Re: scalablility problem
From: Guido Neitzer
Date:
Subject: Re: scalablility problem