Re: 8.3 / 8.2.6 restore comparison

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: 8.3 / 8.2.6 restore comparison
Дата
Msg-id 1203968216.7878.52.camel@dogma.ljc.laika.com
обсуждение исходный текст
Ответ на Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
On Sun, 2008-02-24 at 09:47 -0800, Joshua D. Drake wrote:
> A less hacker and more DBA bottleneck will be to limit the number of 
> backends being created for restore. We don't really want to have more 
> than one backend per CPU, otherwise we just start switching.

Are you sure that it would always be a loss?

If there is any significant I/O latency for a single backend, it seems
like a context switch could be a win for processor utilization. It might
not be a win overall, but at least potentially a win.

Regards,Jeff Davis



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Avahi support for Postgresql
Следующее
От: Mathias Hasselmann
Дата:
Сообщение: Re: [PATCHES] Avahi support for Postgresql