Re: 8.3 / 8.2.6 restore comparison - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 1203968216.7878.52.camel@dogma.ljc.laika.com
Whole thread Raw
In response to Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Avahi support for Postgresql
Next
From: Mathias Hasselmann
Date:
Subject: Re: [PATCHES] Avahi support for Postgresql