public inbox for [email protected]help / color / mirror / Atom feed
Specify bytes storage for enum data types 3+ messages / 3 participants [nested] [flat]
* Specify bytes storage for enum data types @ 2022-05-04 21:20 PG Doc comments form <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: PG Doc comments form @ 2022-05-04 21:20 UTC (permalink / raw) To: [email protected]; +Cc: [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Specify bytes storage for enum data types @ 2022-05-05 12:30 David G. Johnston <[email protected]> parent: PG Doc comments form <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: David G. Johnston @ 2022-05-05 12:30 UTC (permalink / raw) To: [email protected] <[email protected]>; [email protected] <[email protected]> On Wednesday, May 4, 2022, PG Doc comments form <[email protected]> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Specify bytes storage for enum data types @ 2022-05-05 13:04 Sumit Sengupta <[email protected]> parent: David G. Johnston <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Sumit Sengupta @ 2022-05-05 13:04 UTC (permalink / raw) To: David G. Johnston <[email protected]>; [email protected] <[email protected]> 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 <[email protected]> Sent: Thursday, May 5, 2022 8:30 AM To: [email protected] <[email protected]>; [email protected] <[email protected]> Subject: Re: Specify bytes storage for enum data types On Wednesday, May 4, 2022, PG Doc comments form <[email protected]<mailto:[email protected]>> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-05-05 13:04 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-05-04 21:20 Specify bytes storage for enum data types PG Doc comments form <[email protected]> 2022-05-05 12:30 ` David G. Johnston <[email protected]> 2022-05-05 13:04 ` Sumit Sengupta <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox