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