Re: Data Type Size Calculation

2022-02-15 Thread Jian He
https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/ Hope this link is useful. create table testb as select 'true'::bool as b from generate_series(1,100) i;SELECT 100 $ \dt+ testb List of

Re: Data Type Size Calculation

2022-02-15 Thread Troy Frericks
For now, yes... I'm suggesting that the documentation be completed by adding a few sentences few extra sentences. Troy. # On Mon, Feb 14, 2022, 12:51 Bruce Momjian wrote: > On Fri, Feb 11, 2022 at 08:12:08PM +, PG Doc comments form wrote: > > The following documentation comment has been

Re: Data Type Size Calculation

2022-02-14 Thread Bruce Momjian
On Fri, Feb 11, 2022 at 08:12:08PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/datatype-numeric.html > Description: > > > The actual storage requirement is two bytes for each group of four