Re: Parameter value from (mb/gb) to bytes - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Parameter value from (mb/gb) to bytes
Date
Msg-id 20201014151726.GA50753@elch.exwg.net
Whole thread Raw
In response to Re: Parameter value from (mb/gb) to bytes  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
## Magnus Hagander (magnus@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



pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Parameter value from (mb/gb) to bytes
Next
From: Tom Lane
Date:
Subject: Re: Parameter value from (mb/gb) to bytes