[postgis-users] CHAR data type

Leticia lgomez at itba.edu.ar
Wed Mar 21 06:54:28 PDT 2007


I am using PostgreSQL 8.2.3. with the default page size of 8K

 

I created the following table:

 

CREATE TABLE mystate( ID integer, name char(8000) );

 

I inserted three tuples:

 

INSERT INTO mystate VALUES (3, 'a3');

INSERT INTO mystate VALUES (5, 'a5');

INSERT INTO mystate VALUES (6, 'a6');

 

And then I ran the following query:

 

vacuum analyze mystate;           

select relpages, reltuples from pg_class where relname='mystate';

 

 

but the result was:

1                 3

 

 

If I use "char(8000)" instead of "varchar(8000)" why there is no padding and
these three tuples are inside the same page?

 

Thanks in advance,

Leticia

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070321/cfd1a53c/attachment.html>


More information about the postgis-users mailing list