Re: Extent size

Andreas Schmitz wrote:
> On Tuesday 01 October 2002 17:18, Bruce Momjian wrote:
> > Andreas Schmitz wrote:
> > > Hello *,
> > >
> > > is there any way in postgres to define the size of extents ?
> >
> > We don't have extents like Informix.  We use the file system so size is
> > unlimited.  I think that answers your question.
>
> Not really. If I want to store data in a efficient way I normally have a look
> at the size of the data. lets say I've got text blocks of 1.5 kb. I would
> consider to choose an extent size of 2kb instead of 4 kb to save up space.
> Which would be the right consideration for postgres ?

We don't do such optimizations and consider them of limited value.  Our
pages are 8k, and we have backup tables for long values.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073