| From: | Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Extent size |
| Date: | 2002-10-01 16:13:25 |
| Message-ID: | 200210011813.25224.a.schmitz@cityweb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)schmitz(at)cityweb(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-10-01 16:56:30 | Re: Extent size |
| Previous Message | Ferdinand Smit | 2002-10-01 15:52:49 | pg_dump error |