Re: Specify bytes storage for enum data types - Mailing list pgsql-docs

From Sumit Sengupta
Subject Re: Specify bytes storage for enum data types
Date
Msg-id BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29@BL0PR06MB4978.namprd06.prod.outlook.com
Whole thread Raw
In response to Re: Specify bytes storage for enum data types  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
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. 

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Specify bytes storage for enum data types
Next
From: PG Doc comments form
Date:
Subject: Docs about INSERT wait in Read Commited transaction