Forum Post: RE: DB crash a short time after increasing -B to 200000

  • Thread starter Thread starter gus
  • Start date Start date
Status
Not open for further replies.
G

gus

Guest
@Stefan: smartphones do not run windoze. (well, ok, i lied, there are two people using windoze phones) in theory you are correct, we should not allow values that will cause a problem. unfortunately, in practice, this is not possible. On 32-bit Windoze a process address space is limited to 2gb. that includes all code, stacks, dynamically allocated heap, shared libraries and a host of other things. this limits the effective address space that can be used for database connections to about 1.7 GB under /ideal conditions/. There are no system calls that allow you to ask "how much memory can i attach" or related questions. even if there were, by the time you got the answer and attempted such a feat, the answer might have changed. the fact is, 32-bit operating systems are no longer suitable and should be abandoned as soon as possible. in the meantime use smaller -B (actually -B +-B2) and don't connectto multiple databases. try -shmsegsize 128.

Continue reading...
 
Status
Not open for further replies.
Back
Top