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

From Steinar H. Gunderson
Subject Re: Throttling PostgreSQL's CPU usage
Date
Msg-id 20070508205120.GA7983@uio.no
Whole thread Raw
In response to Throttling PostgreSQL's CPU usage  (Daniel Griscom <griscom@suitable.com>)
Responses Re: Throttling PostgreSQL's CPU usage  (Carlos Moreno <moreno_pg@mochima.com>)
List 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/

pgsql-performance by date:

Previous
From: Charles Sprickman
Date:
Subject: Re: Best OS for Postgres 8.2
Next
From: Bill Moran
Date:
Subject: Re: Throttling PostgreSQL's CPU usage