Re: Tuple, table, database object identifiers size

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Tuple, table, database object identifiers size
Date: 2002-08-29 19:52:06
Message-ID: 200208291952.g7TJq6q20629@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)csd(dot)uch(dot)gr)
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message snpe 2002-08-29 20:22:05 Re: Compiling 7.2.1 with JDBC-Support fails - help needed
Previous Message Peter E. Chen 2002-08-29 19:51:13 Question Regarding Geometric Operators/Function . . .