Обсуждение: 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/ > 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