Re: [HACKERS] Why standby.max_connections must be higher than primary.max_connections?

2013-12-12 Thread satoshi yamada
>> Because the KnownAssignedXIDs and lock tables on the standby need to >> be large enough to contain the largest snapshot and greatest number of >> AccessExclusiveLocks that could exist on the master at any given time. > > Right. Initially during the development of Hot Standby, it looked like > th

Re: [HACKERS] Why standby.max_connections must be higher than primary.max_connections?

2013-12-11 Thread satoshi yamada
>> Hello hackers. >> >> I am struggling to understand why standby.max_connections must be higher >> than >> primary.max_connections.Do someone know the reason why? > > Because the KnownAssignedXIDs and lock tables on the standby need to > be large enough to contain the largest snapshot and greatest