Re: Billions of records?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org
Subject: Re: Billions of records?
Date: 2003-07-21 21:43:34
Message-ID: 200307212143.h6LLhY721461@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have an internals presentation on my home page below. There is a PDF
that will give a general overview,and of course the source code has the
details.

---------------------------------------------------------------------------

Jim C. Nasby wrote:
> On Wed, Jul 16, 2003 at 06:07:22PM -0400, Tom Lane wrote:
> > "Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> > > BTW, is there any documentation on the structure of index pages?
> >
> > Same as heap pages...
> > http://developer.postgresql.org/docs/postgres/page.html
> > The index tuple header layout is different from heap tuple headers,
> > but the other info on that page applies.
>
> Sorry, said one thing and meant another... is there documentation on
> index *tuple* layout?
> --
> Jim C. Nasby, Database Consultant jim(at)nasby(dot)net
> Member: Triangle Fraternity, Sports Car Club of America
> Give your computer some brain candy! www.distributed.net Team #1828
>
> Windows: "Where do you want to go today?"
> Linux: "Where do you want to go tomorrow?"
> FreeBSD: "Are you guys coming, or what?"
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
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 Bruce Momjian 2003-07-21 22:04:18 Re: [GENERAL] [BUGS] pg_tables view definition incorrect??
Previous Message Bruce Momjian 2003-07-21 21:00:40 Re: perfromance impact of vacuum