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

From Jim C. Nasby
Subject Re: Billions of records?
Date
Msg-id 20030716194532.GR5877@nasby.net
Whole thread Raw
In response to Re: Billions of records?  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Billions of records?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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?

BTW, is there any documentation on the structure of index pages?
--
Jim C. Nasby, Database Consultant                  jim@nasby.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?"

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?