## Magnus Hagander (mag...@hagander.net): > 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