Tgl wrote:
> > As I see it, this means the user-locks (and perhaps all
> > locks...?) eat around ~ 6k bytes memory each.
>
> They're allocated in groups of 32, which would work out to close to
6k;
> maybe you were measuring the incremental cost of allocating the first
one?
I got my 6k figure by dividing 10000 into 64M, 10000 being the value
that crashed the server. That's reasonable because doubling shared
buffers slightly more than doubled the crash value.
I was wondering how ~ 10k locks ran me out of shared memory when each
lock takes ~ 260b (half that, as you say) and I am running 8k buffers =
64M.
260 * 100 backends * 64 maxlocks = 1.7 M. Sure, the hash table and
other stuff adds some...but this is no where near what it should take to
run me out.
Am I just totally misunderstanding how to estimate locks memory
consumption?
Merlin
