Re: BLCKSZ

Поиск
Список
Период
Сортировка
От Ross J. Reedstrom
Тема Re: BLCKSZ
Дата
Msg-id 20000517141345.A24926@rice.edu
обсуждение исходный текст
Ответ на BLCKSZ  ("Robert B. Easter" <reaster@comptechnews.com>)
Список pgsql-general
On Wed, May 17, 2000 at 02:53:17PM -0400, Robert B. Easter wrote:
>
> If I set the block size from 8k to 16k by editing /include/config.h, then all
> tuples will take up 16k on disk?  If true, it just wastes lots of disk space if
> you are really not going to be storing more than 8k in most tuples?

Currently, more than one tuple can be stored in a block, it's just that
any one tuple cannot be stored in more than one block: i.e. tuples cannot
span blocks, so the BLKSZ sets the maximum tuple size. Clear?

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

В списке pgsql-general по дате отправления:

Предыдущее
От: "Robert B. Easter"
Дата:
Сообщение: BLCKSZ
Следующее
От: Jeffery Collins
Дата:
Сообщение: initdb and "exit_nicely"...