Thread: Specify bytes storage for enum data types

Specify bytes storage for enum data types

From
PG Doc comments form
Date:
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 every
) 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 !

Thanks
- Sumit Sengupta

Re: Specify bytes storage for enum data types

From
"David G. Johnston"
Date:


On Wednesday, May 4, 2022, PG Doc comments form <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 every
) 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. 

Re: Specify bytes storage for enum data types

From
Sumit Sengupta
Date:
Thanks 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. 

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.postgresql.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> 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 every
) 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.