[ADMIN] 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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] Extent size
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 [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 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] Extent size
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] 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 [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