Skip site navigation (1) Skip section navigation (2)

Re: Pg on SMP half-powered

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Víctor Romero <romero(at)kde(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pg on SMP half-powered
Date: 2001-07-05 17:34:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
What is the postgres process doing?  what does iostat show for disk I/O?
from reading this, you are comparing apples->oranges ... are the drives
the same on the non-SMP as the SMP?  amount of RAM?  speed of CPUs?  hard
drive controllers with same amount of cache on them? etc, etc, etc ...

On Thu, 5 Jul 2001, [iso-8859-1] Vctor Romero wrote:

>  Hello, hackers!
>  I am running postgresql 7.1 on a SMP Linux box. It runs, but it never pass a
> loadavg of 0.4, no matter how I try to overload the system.
>  The same configuration, the same executable, the same test on a non-SMP
> machine gives a loadavg of 19.
>  That means that a Xeon SMP box with 1Gb of RAM goes slowlier than a weak
> CPU, with the same postgres, the same configuration, and the same test.
>  Anybody knows what is happening? Is there something to do on a SMP machine
> for it to run? I tried with lots of shared memory, and with "commit_delay=0",
> but nothing worked.
>  Yours:
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org

In response to


pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-07-05 17:37:09
Subject: Checking query results against selectivity estimate
Previous:From: John MooreDate: 2001-07-05 16:48:35
Subject: Re: [OT] Any major users of postgresql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group