public inbox for [email protected]  

help / color / mirror / Atom feed

From: Morten Hustveit <[email protected]>
To: [email protected]
Subject: Size limit on GiST nodes not documented
Date: Sat, 22 Dec 2012 14:59:01 +0100
Message-ID: <CAL3abtUPLt4o2oL8z2w4tuqj8qZ1QDcXsm43upUE-Yo=Cam9sQ@mail.gmail.com> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

In GiST indexes, storing nodes larger than an index page is apparently
not allowed.  This prohibits, for example, storing 600 entry float8
arrays in the index.  For SP-GiST in PostgreSQL 9.2, it was decided
that this should be documented:

  "Individual leaf tuples and inner tuples must fit on a single index
page (8KB by default)."[1]

... but for GiST indexes, this is never mentioned explicitly.  The
result was that I wasted many hours developing a GiST index before
noticing it could not be used with my data.

1. http://www.postgresql.org/docs/9.2/static/spgist-implementation.html#SPGIST-LIMITS


-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Size limit on GiST nodes not documented
  In-Reply-To: <CAL3abtUPLt4o2oL8z2w4tuqj8qZ1QDcXsm43upUE-Yo=Cam9sQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox