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,
On Wed, Mar 21, 2007 at 11:29:54AM -0300, Leticia wrote:
If I use char(8000) instead of varchar(8000) why there is no padding and
these three tuples are inside the same page?
http://www.postgresql.org/docs/8.2/interactive/datatype-character.html
The storage requirement for data of these types