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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
