CHAR data type

From: "Leticia" <lgomez(at)itba(dot)edu(dot)ar>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: CHAR data type
Date: 2007-03-21 14:29:54
Message-ID: !&!AAAAAAAAAAAYAAAAAAAAAIp4oCwdczpFp3BQ+cTGVObCgAAAEAAAAImdbbaM2ltCji8I3RlcZwwBAAAAAA==@itba.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

Attachment Content-Type Size
ATT00007.txt text/plain 175 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Arai 2007-03-21 14:43:43 multi terabyte fulltext searching
Previous Message Tijnema ! 2007-03-21 14:27:58 Re: [PHP] Re: phpPgAdmin - prior version available?

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2007-03-21 14:40:37 Re: Formating Date Data Type?
Previous Message Ashish Karalkar 2007-03-21 07:05:35 Re: Formating Date Data Type?