Re: Throttling PostgreSQL's CPU usage

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Throttling PostgreSQL's CPU usage
Date: 2007-05-08 20:51:20
Message-ID: 20070508205120.GA7983@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 08, 2007 at 04:27:10PM -0400, Daniel Griscom wrote:
> 3: ... some other solution I haven't thought of.

On a wild guess, could you try setting the CPU costs higher, to make the
planner choose a less CPU-intensive plan?

Other (weird) suggestions would include calling a user-defined function that
sleep()ed for you between every row. Or use a dual-core system. :-)

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2007-05-08 20:55:49 Re: Throttling PostgreSQL's CPU usage
Previous Message Charles Sprickman 2007-05-08 20:49:58 Re: Best OS for Postgres 8.2