Re: index storage planning - Mailing list pgsql-general

From Ray Stell
Subject Re: index storage planning
Date
Msg-id 20091120150304.GA31586@cns.vt.edu
Whole thread Raw
In response to index storage planning  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-general
On Thu, Nov 19, 2009 at 10:43:57AM -0500, Ray Stell wrote:
> Is there a doc that covers planning disk storage of indices?

http://www.postgresql.org/docs/8.4/interactive/storage-page-layout.html#FTN.AEN82952
53.5. Database Page Layout

http://archives.postgresql.org/pgsql-docs/2002-04/msg00003.php
"If you want to know how much space something is going to take, create
it and look at it.  I don't think we want to get users involved into
counting the bits of each piece of overhead that comes with a database."

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange performance degradation
Next
From: Tom Lane
Date:
Subject: Re: how to use a cursor for update?