[postgis-users] CHAR data type

[TECHER David]

You're not in postgresql mailing-list here

it should be better to ask on irc

server: irc.freenode.net

chan #postgresql

Leticia a écrit :
>
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com