Re: index storage planning

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: index storage planning
Date: 2009-11-20 15:03:04
Message-ID: 20091120150304.GA31586@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-20 15:05:55 Re: how to use a cursor for update?
Previous Message Tom Lane 2009-11-20 14:49:59 Re: Strange performance degradation