| From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: BLCKSZ |
| Date: | 2000-05-17 19:13:45 |
| Message-ID: | 20000517141345.A24926@rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffery Collins | 2000-05-17 19:19:47 | initdb and "exit_nicely"... |
| Previous Message | mikeo | 2000-05-17 19:09:07 | Re: remove line type? |