Re: Extent size
От | Andreas Schmitz |
---|---|
Тема | Re: Extent size |
Дата | |
Msg-id | 200210011813.25224.a.schmitz@cityweb.de обсуждение исходный текст |
Ответ на | Re: Extent size (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Extent size
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: