A question about pages

Поиск
Список
Период
Сортировка
От tmorelli@tmorelli.com.br
Тема A question about pages
Дата
Msg-id 20060110221837.1EF51F3A40@smtpi01.infolink.com.br
обсуждение исходный текст
Ответы Re: A question about pages  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Vanja
Дата:
Сообщение: Re: translating this SQL query from a different dialect
Следующее
От: Tom Lane
Дата:
Сообщение: Re: A question about pages