A question about pages - Mailing list pgsql-novice

From tmorelli@tmorelli.com.br
Subject A question about pages
Date
Msg-id 20060110221837.1EF51F3A40@smtpi01.infolink.com.br
Whole thread Raw
Responses Re: A question about pages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

I've been studying about how PostgreSQL uses pages (data and indexes) lately.
And, I guess, I found out a strange thing (bizarre!)

After creating a table with just one field (char(2048)), and an index, I
inserted 5 rows. But, surprisingly, my table still uses just one page! Even
having 5 x 2048  = 10.240 bytes, How could it be possible? (the page size is 8K)

I've made the test over and over. Where did I make a mistake? Looking at "ls"
information, I see that the file size is 8192 bytes

Could anyone help me?

best regards

Eduardo Morelli

pgsql-novice by date:

Previous
From: Vanja
Date:
Subject: Re: translating this SQL query from a different dialect
Next
From: Tom Lane
Date:
Subject: Re: A question about pages