Clarification on documentation

From: Keaton Adams <kadams(at)mxlogic(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Clarification on documentation
Date: 2008-10-06 15:26:03
Message-ID: C50F8A2B.623E%kadams@mxlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just wanted to clarify something in the Docs.

An "index" page.....

If I create an index on a table for column foo character(8) would that require:

Character value overhead: 4 bytes

Per index page: 20 bytes

Row offset per index entry: 4 bytes
Row fixed-size header per index entry: 27 bytes

Does that sound correct?

Thanks,

Keaton

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2008-10-06 15:26:49 Re: Frustrated...pg_dump/restore
Previous Message ries van Twisk 2008-10-06 15:16:04 Re: Frustrated...pg_dump/restore