Re: determining extent sizes

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/01/19
Message-ID: <Pine.SUN.3.91.960119100454.4997B-100000_at_seatimes>#1/1

On Wed, 17 Jan 1996, Chuck Hamilton wrote:

> I'm curious as to what other DBAs do when creating new tables. Is it
> better to:
>
> 1) estimate actual table sizes and create the initial extent to be
> that size,
>
> or
>
> 2) make all extents the same size so it's easier for the RDBMS to
> reuse free'd up extents?
>

Yes to both. I standardize on a block size then use multiples of that size for the initial and Next. In a recent multi-gig database I used 512K for the initial and next on anything small (under 2Meg total).

Over 2 Meg, I used a multiple of 4 Meg for the initial and next. Usually tried to run Next about 1/4 to 1/2 the size of initial. But never smaller than 4Meg. One had an initial of 256M and Next of 64M.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Fri Jan 19 1996 - 00:00:00 CET