Re: Billions of records? - Mailing list pgsql-general

From Tom Lane
Subject Re: Billions of records?
Date
Msg-id 25467.1058393242@sss.pgh.pa.us
Whole thread Raw
In response to Re: Billions of records?  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Billions of records?  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-general
"Jim C. Nasby" <jim@nasby.net> writes:
> On Tue, Jul 15, 2003 at 07:53:37PM +0530, Shridhar Daithankar wrote:
>> Each tuple in postgresql has around 28 bytes of overhead. Index tuple has 12

> Is this accurate?
> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=page.html
> indicates a per-tuple overhead of 23 bytes. Or have things changed in
> 7.4?

He's probably assuming you are using OIDs (which is the default).

> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Install new language - Prev: Re: Are you frustrated with PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?