From: Sumit Sengupta <ssengupta@hotmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: Specify bytes storage for enum data types
Thread-Topic: Specify bytes storage for enum data types
Thread-Index: AQHYX/zeuuiqct+NoEqymVq3LlBqqq0QN/gAgAAJIfw=
Date: Thu, 5 May 2022 13:04:18 +0000
Message-ID: 
 <BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29@BL0PR06MB4978.namprd06.prod.outlook.com>
References: <165169921944.683.8982699018922635049@wrigleys.postgresql.org>
 <CAKFQuwauVwwr7_3zYtM3ACEJfQN+LimohSFGKX5opAs3CH2Liw@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwauVwwr7_3zYtM3ACEJfQN+LimohSFGKX5opAs3CH2Liw@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [taKfqM3be+JId+KrOYJBHThWs1xHt2qk]
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: 1869b372-acc2-4ff8-03dd-08da2e97c3c1
x-ms-traffictypediagnostic: BYAPR06MB4342:EE_
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 iyqLVvLx/Ux1a+Cqa9XsFcuhLsPlS3LYHqv5A7wqADgWdRUeiQTrT52gLqpt/Wpby74XKDqoeuz/j0BqjlATV3JX0sNuS0lFCPTsjDHHBQt5rMKKHj+xwT6MZq2uvygQdkXc7qsXZT6Ud+i8ULpBww7y9XRT31d1VT/9zGlHKdLZFn9C2xqzrugur/HnGDWXad3zDcUnBLMM0AUBRFstnNqpfq0ZQ6y4inhHkxI6SagySSMWrrAa0j6KqoV8UfauNKPrzY2Ix5849uICM1KrY5xdX+jmACI/It3v96Ntvme1qtaFEglxlfif1HGvaawJIVpgSMqzlol3AbEtDl4zW3tvzHw+QNiLCIv6wLcE6aNFDueobGMc/uKQfwS4tO5UcewfYQINTdE6OAQbPjLaFBn2gUQiL5LIpuIrshFsZt1qJ/L7OU01dqnmTIKuweLmzqolqDEUnaaQOdBTtL4Zl5hxDyDz6oSNDUNi+WBdTvyC54u0VDQn0R1t4Re3oN6x7fWuRfnuo+zEKoWU6M2FlKephaGNCkBGcSI5oAFE3ocB1blEOvEtrr/At/ZojJWSZMhQuzsxkPSMXr5kfa6MdXf32DuG2OeZ2uv3W9+jbk1iRn9o3aSWTDLtyB/oMZ8TQGgQEy5qOqV5VNkHAA7UmkrO35gZKLKJ9YIJz99CnmzgjnPg6NiTi6J9wdQWQkCrO/SQJGFYhGHrMsImeydu0Q==
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?D6+5K8ZCXlRLFVcP9hZJQMNuZF+4mIWwvXCwtiyNpcxCzlqzVdYpr1Qe2gbQ?=
 =?us-ascii?Q?Cdlb9JMIgBf3K3wGlYvSUYbX/4Mx2gz3yqJ3vVE2l+lTkWRsHIWxsjusafoS?=
 =?us-ascii?Q?RQzloRLXkqYPMtuRsTQP6RYvf+EZX9pSeEb57eXfM/yi4CW/CmH+OaKqL16H?=
 =?us-ascii?Q?27Mqv8Dp6kYDrsqEAuFdJqSsbyTeWM2njUZOBe7ul9VdM3LNDMUf3MUEsZhM?=
 =?us-ascii?Q?V1fp/UXI1FdTT0rVVoYaT3bLmsBSItTvYGmUu+drGvkJ1kgN1/XpVvFu7mpA?=
 =?us-ascii?Q?0WY8PO02m7PfAmvydnbBP+/pW5Ci0oqgIB5k2QEmBr7a1nHJESL1p4iSmWN8?=
 =?us-ascii?Q?2MI1JxZIGN1fDcnVMWEArZOodnKDELMOZOnSp0PC/QF6uXiwFFTtHRhwqHU3?=
 =?us-ascii?Q?fY3ihUiEJUVIKCNPvu0p8Zv8ERw+7nEruU2anr1JM4siEbcAXKzhQPpqiZ/U?=
 =?us-ascii?Q?WbSGzGpUxHZspd97CGjm+qOeDuiuZgdyMJsZLnoQClXjFDI/bbR4BcM5FXRV?=
 =?us-ascii?Q?ABmoQb7+UnCeav6LdF1ToeqGy5q9hcYuPvNQj4YXb/LW0i+hpDOV78kUOjxp?=
 =?us-ascii?Q?nSjvGo24E3MzQfUBCIYEpvSwouPFCpbT+AIs9TxUqEDpoCWC38rbT+URo0NY?=
 =?us-ascii?Q?VZAzKeaEfNFkhrx+Xqtswu11yplH8Gx2K6w78gWy35phDA2xv1mvJFITIxjJ?=
 =?us-ascii?Q?4aBa2BsBRWf7xOF+39JUQIw3W2UZTBbW8Tj/krk0+9x6LZvOVFf0iuE/ClHX?=
 =?us-ascii?Q?yDPirAPemILuAhQlimv4UyBXZ7ON9DvZTJngDpRv5Ek9UoyaLUOemmXq4Liz?=
 =?us-ascii?Q?rLyHwWgqV76bx1Dq0g5YF2AsAbXY5H5yRApWSVIXiR0JLBrDJ/vvgmJxRelt?=
 =?us-ascii?Q?84QmgtJCjl0YesdfnLPglYan+6Ijtj/lK1ZxvWikKfutEfmc8Ky7mNiCa8V5?=
 =?us-ascii?Q?J9b+edH9CpmtsK9wQWNUuA7wTGlMGh7hWHL6AW8btrPT7csQc87MJId4QPKC?=
 =?us-ascii?Q?vsYaqVw/u7vWWkd4rNtZuWi8UNPyYIEoJ/olsaNxUkHo/ASy2b4fAfDJxOt6?=
 =?us-ascii?Q?MWsM9EzmCEqAsjWefDwoRmN1tUk3FmJElFQJOONMgCxs/+atqHO+CYZm7YZe?=
 =?us-ascii?Q?VD7so2LPd1ZmnpnUPSb5936dXiyxoKNV0Te5uxChBQ1OtjqLLDI9yjAeNRvu?=
 =?us-ascii?Q?3R86jZyixK+fKmT17bUuJkgA465IVCwtT1B23KX5sh9kz8Y8WYGD2gsZStId?=
 =?us-ascii?Q?xRtKfwJC42LEBcTM6cBnJCxDtWniAT9W8qFyavTI6a1uZwu+zonDgsZf59Yf?=
 =?us-ascii?Q?K+ykEotUWQbEfD+2PnzBh9dsXfr15YrE8RvqhFIrcR2kSEnsE7GOuILqWvyb?=
 =?us-ascii?Q?O4oJFoI32zfBehhbLOL+iQS1bV2ndKml38e39t0T8FqTKEmXzF+D9hP/mM2n?=
 =?us-ascii?Q?FdmMjxA8EIs=3D?=
Content-Type: multipart/alternative;
	boundary="_000_BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29BL0PR06MB4978namp_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-89723.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BL0PR06MB4978.namprd06.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 1869b372-acc2-4ff8-03dd-08da2e97c3c1
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 May 2022 13:04:18.4867
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BYAPR06MB4342
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29%40BL0PR06MB4978.namprd06.prod.outlook.com>
Precedence: bulk

--_000_BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29BL0PR06MB4978namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Thanks David. I overlooked that at the bottom. I guess it would still be ni=
ce to mention the storage at the top like other data types.
________________________________
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Thursday, May 5, 2022 8:30 AM
To: ssengupta@hotmail.com <ssengupta@hotmail.com>; pgsql-docs@lists.postgre=
sql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Specify bytes storage for enum data types


On Wednesday, May 4, 2022, PG Doc comments form <noreply@postgresql.org<mai=
lto:noreply@postgresql.org>> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/datatype-enum.html
Description:

I love Postgres !! And also its documentation !!

While reading through data types, it occurred to me that most ( if not ever=
y
) other data types has a chart on the top saying how many bytes it
occuies.
Like all numerical, date or char data types.

For enum it would be nice to have that info as well.
I am assuming it is variable ? May be 1 or 2 bytes for the definition and
the rest depending on the enum values ?

A clarification would be nice !

Second to last sentence on the page.

Storage only measures the size of a single value on a data row.

David J.

--_000_BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29BL0PR06MB4978namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div style=3D"font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;=
 color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class=3D"eleme=
ntToProof">
Thanks&nbsp;David. I overlooked that at the bottom. I guess it would still =
be nice to mention the storage at the top like other data types.&nbsp;</div=
>
<div id=3D"appendonsend"></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> David G. Johnston &lt=
;david.g.johnston@gmail.com&gt;<br>
<b>Sent:</b> Thursday, May 5, 2022 8:30 AM<br>
<b>To:</b> ssengupta@hotmail.com &lt;ssengupta@hotmail.com&gt;; pgsql-docs@=
lists.postgresql.org &lt;pgsql-docs@lists.postgresql.org&gt;<br>
<b>Subject:</b> Re: Specify bytes storage for enum data types</font>
<div>&nbsp;</div>
</div>
<div><br>
<br>
On Wednesday, May 4, 2022, PG Doc comments form &lt;<a href=3D"mailto:norep=
ly@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br>
<blockquote class=3D"x_gmail_quote" style=3D"margin:0 0 0 .8ex; border-left=
:1px #ccc solid; padding-left:1ex">
The following documentation comment has been logged on the website:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/datatype-enum.html" tar=
get=3D"_blank">
https://www.postgresql.org/<wbr>docs/14/datatype-enum.html</a><br>
Description:<br>
<br>
I love Postgres !! And also its documentation !!<br>
<br>
While reading through data types, it occurred to me that most ( if not ever=
y<br>
) other data types has a chart on the top saying how many bytes it<br>
occuies.<br>
Like all numerical, date or char data types.<br>
<br>
For enum it would be nice to have that info as well.<br>
I am assuming it is variable ? May be 1 or 2 bytes for the definition and<b=
r>
the rest depending on the enum values ? <br>
<br>
A clarification would be nice !<br>
</blockquote>
<div><br>
</div>
<div>Second to last sentence on the page.</div>
<div><br>
</div>
<div>Storage only measures the size of a single value on a data row.</div>
<div><br>
</div>
<div>David J.&nbsp;</div>
</div>
</body>
</html>

--_000_BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29BL0PR06MB4978namp_--