Re: Throttling PostgreSQL's CPU usage - Mailing list pgsql-performance

From david@lang.hm
Subject Re: Throttling PostgreSQL's CPU usage
Date
Msg-id Pine.LNX.4.64.0705081622320.29403@asgard.lang.hm
Whole thread Raw
In response to Re: Throttling PostgreSQL's CPU usage  (Carlos Moreno <moreno_pg@mochima.com>)
Responses Re: Throttling PostgreSQL's CPU usage  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-performance
On Tue, 8 May 2007, Carlos Moreno wrote:

> Daniel Griscom wrote:
>>
>>  Several people have mentioned having multiple processors; my current
>>  machine is a uni-processor machine, but I believe we could spec the actual
>>  runtime machine to have multiple processors/cores.
>
> My estimate is that yes, you should definitely consider that.
>
>>  I'm only running one query at a time; would that query be guaranteed to
>>  confine itself to a single processor/core?
>
> From what Joshua mentions, looks like you do have that guarantee.

isn't there a way to limit how many processes postgres will create?

if this is limited to 1, what happens when a vaccum run hits (or
autovaccum)

David Lang


pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: Throttling PostgreSQL's CPU usage
Next
From: "Orhan Aglagul"
Date:
Subject: