Hi!
Thank you for explanations.
the char type pads out the fields on disk.
It looks like you wrote that char takes more disk space.
from
http://www.pgcon.org/2013/schedule/attachments/269_tour-of-postgresql-data-types.pdf
page 28:
Unlike many
databases, char(n) is NOT stored as afixed-sizedfield
in Postgres. It is treated exactly the sameas
varchar(n)except for being padded
So char type does not take more space than varchar.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
