Thread: Extent size
Hello *, is there any way in postgres to define the size of extents ? regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email a.schmitz@cityweb.de
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. -- 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
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 ? regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email a.schmitz@cityweb.de
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