From: Joshua D. Drake <jd@commandprompt.com>
To: Carlos Moreno <moreno_pg@mochima.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Throttling PostgreSQL's CPU usage
Date: Tue, 08 May 2007 15:39:55 -0700
Message-ID: <4640FC3B.3000608@commandprompt.com> (raw)
In-Reply-To: <4640FA6E.4050003@mochima.com>
References: <p0624080bc266892a91b2@[192.168.1.8]>
<20070508205120.GA7983@uio.no>
<4640FA6E.4050003@mochima.com>
Carlos Moreno wrote:
> Steinar H. Gunderson wrote:
>> Or use a dual-core system. :-)
>
> Am I missing something?? There is just *one* instance of this idea in,
> what,
> four replies?? I find it so obvious, and so obviously the only solution
> that
> has any hope to work, that it makes me think I'm missing something ...
>
> Is it that multiple PostgreSQL processes will end up monopolizing as many
> CPU cores as you give it? (ok, that would suck, for sure :-))
PostgreSQL is process based, so if you have one query that is eating a
lot of cpu, it is only one cpu... you would have another for your render
to run on.
Joshua D. Drake
>
> If there is a way to guarantee (or at least to encourage) that PG will
> not use
> more than one, or even two cores, then a quad-core machine looks like a
> promising solution... One thing feels kind of certain to me: the kind of
> system that the OP describes has a most-demanding need for *extremely
> high* CPU power --- multi-core, or multi-CPU, would seem the better
> solution anyway, since it promotes responsiveness more than raw CPU
> power.
>
> Carlos
> --
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, moreno_pg@mochima.com
Subject: Re: Throttling PostgreSQL's CPU usage
In-Reply-To: <4640FC3B.3000608@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox