Closed Tigrov closed 8 months ago
Tables are created with type varchar(128) https://github.com/yiisoft/rbac-db/blob/master/sql/pgsql-up.sql
varchar(128)
In Postgres this type adds 4 bytes: The storage requirement for a short string (up to 126 bytes) is 1 byte plus the actual string... Longer strings have 4 bytes of overhead instead of 1. https://www.postgresql.org/docs/current/datatype-character.html
It makes sense to change the type to varchar(126)
varchar(126)
Tables are created with type
varchar(128)https://github.com/yiisoft/rbac-db/blob/master/sql/pgsql-up.sqlIn Postgres this type adds 4 bytes: The storage requirement for a short string (up to 126 bytes) is 1 byte plus the actual string... Longer strings have 4 bytes of overhead instead of 1. https://www.postgresql.org/docs/current/datatype-character.html
It makes sense to change the type to
varchar(126)