Re: Throttling PostgreSQL's CPU usage

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Throttling PostgreSQL's CPU usage
Дата
Msg-id 20070508205120.GA7983@uio.no
обсуждение исходный текст
Ответ на Throttling PostgreSQL's CPU usage  (Daniel Griscom <griscom@suitable.com>)
Ответы Re: Throttling PostgreSQL's CPU usage
Список 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 по дате отправления:

Предыдущее
От: Charles Sprickman
Дата:
Сообщение: Re: Best OS for Postgres 8.2
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Throttling PostgreSQL's CPU usage