## Magnus Hagander (magnus@xxxxxxxxxxxx):
> Actually, it doesn't have to be in 8k pages, that depends on the build
> options. So if you want to be perfectly correct, you should probably
> multiply with current_setting('block_size') instead of a hardcoded 8192 :)
More self-contained:
select pg_size_bytes(setting) * pg_size_bytes(unit)
from pg_settings
where name = 'shared_buffers';
I guess that's what that unit column is there for.
Regards,
Christoph
--
Spare Space
