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
_______________________________________________
postgis-users mailing list
[EMAIL PROTECTED]
http://postgis.refractions.net/mailman/listinfo/postgis-users
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
