Re: Extending to 32K row limit

At 11:17 AM 8/8/00 -0700, G. Anthony Reina wrote:
>Thanks Don. One more question: Does Postgres set aside an entire 8 K (or
32 K) of
>hard disk space for the row; or, does it just use what's needed to store the
>information? For example, if I only have one integer value in a row, does
Postgres
>set aside 8K of harddrive space or just sizeof(int) space (with some
pointer where
>other values in the row could be placed on the disk)?

No, it does not allocate a fixed 8K (or 32K) block per row.   The size of a
row is dependent on the data stored within the row.  Each row also contains
a header of modest length.



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.