From: | Morten Hustveit <morten(dot)hustveit(at)gmail(dot)com> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Size limit on GiST nodes not documented |
Date: | 2012-12-22 13:59:01 |
Message-ID: | CAL3abtUPLt4o2oL8z2w4tuqj8qZ1QDcXsm43upUE-Yo=Cam9sQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-12-22 19:54:39 | Re: Wrong function name in the docs |
Previous Message | Metin Döşlü | 2012-12-18 10:11:59 | Wrong function name in the docs |