Tuple, table, database object identifiers size
I have installed a postgres in a SunOS 5.8 sparc SUNW,Sun-Blade-1000. By
default when i create a table of the form (int4, int4) which is the
average tuple size except of the theoretical 4+4 =8 bytes of data
size, including all the object identifiers that I suppose that are
included? Namely which default object identifiers are included in each
tuple and consequently to each table, database storage. Thank you!
SWTHRHS TOYRTOYNHS
(tourtoun@csd.uch.gr)
It's in the docs somewhere but I think it's about 40 bytes.
On Thu, Aug 29, 2002 at 02:03:35PM +0300, Tourtounis Sotiris wrote:
I have installed a postgres in a SunOS 5.8 sparc SUNW,Sun-Blade-1000. By
default when i create a table of the form (int4, int4) which is the
average tuple size except of the theoretical 4+4 =8 bytes of data
size, including all the object identifiers that I suppose that are
included? Namely which default object identifiers are included in each
tuple and consequently to each table, database storage. Thank you!SWTHRHS TOYRTOYNHS
(tourtoun@csd.uch.gr)---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
Martijn van Oosterhout wrote:
It's in the docs somewhere but I think it's about 40 bytes.
It is in the FAQ.
On Thu, Aug 29, 2002 at 02:03:35PM +0300, Tourtounis Sotiris wrote:
I have installed a postgres in a SunOS 5.8 sparc SUNW,Sun-Blade-1000. By
default when i create a table of the form (int4, int4) which is the
average tuple size except of the theoretical 4+4 =8 bytes of data
size, including all the object identifiers that I suppose that are
included? Namely which default object identifiers are included in each
tuple and consequently to each table, database storage. Thank you!SWTHRHS TOYRTOYNHS
(tourtoun@csd.uch.gr)---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
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