Re: [HACKERS] background processes vs. hot standby

2013-06-07 Thread Robert Haas
On Fri, May 24, 2013 at 12:35 PM, Robert Haas wrote: > But I don't know what to do about the problem of needing to know how > many backends there are. I agree with Andres that it's not very > friendly to enforce a restriction that all the same worker processes > must be present on the standby. O

Re: [HACKERS] background processes vs. hot standby

2013-05-24 Thread Robert Haas
On Fri, May 24, 2013 at 11:25 AM, Alvaro Herrera wrote: > Andres Freund escribió: >> I wonder if we shouldn't make background workers use connections slots >> from max_connections similar to how superuser_reserved_connections >> work. That would mean we don't need to care about it for HS. > > I re

Re: [HACKERS] background processes vs. hot standby

2013-05-24 Thread Alvaro Herrera
Andres Freund escribió: > I wonder if we shouldn't make background workers use connections slots > from max_connections similar to how superuser_reserved_connections > work. That would mean we don't need to care about it for HS. I remember considering this and concluding that it's messy. Suppose

Re: [HACKERS] background processes vs. hot standby

2013-05-24 Thread Andres Freund
Hi, On 2013-05-24 09:48:03 -0400, Robert Haas wrote: > CheckRequiredParameterValues() has some code that, when hot standby is > in use, checks the values of max_connections, > max_prepared_transactions, and max_locks_per_transaction against the > master. The comment says "we must have at least a