scott.marlowe wrote:
> I'm pretty sure sort buffer is measured in k, not 8k units. i.e.
>
> 16384 sort mem is 16 Megs.
>
> Or are you referring to something other than sort_mem?
>
It seems that you are correct. Just took a look at the configuration
file and while shared_buffers are in 8K units, or seem to be the
sort_mem is in K units meaning that I am allocating less then expected.
128 x 1024 / 8 = 16384 (shared_buffers)
20 x 1024 = 20480 (sort_mem)
Are these numbers normal? Since they start you out at considerably
higher then the default/minimum values that PostgreSQL advertises in
it's configuration file.
Martin Foster
Creator/Designer Ethereal Realms
martin@ethereal-realms.org