Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tn1bX-000185-Pz for pgsql-docs@arkaria.postgresql.org; Mon, 24 Dec 2012 06:33:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tn1bW-0001t8-He for pgsql-docs@arkaria.postgresql.org; Mon, 24 Dec 2012 06:33:38 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TmPbn-0004Rw-OO for pgsql-docs@postgresql.org; Sat, 22 Dec 2012 13:59:23 +0000 Received: from mail-ie0-f172.google.com ([209.85.223.172]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TmPbm-0006us-I2 for pgsql-docs@postgresql.org; Sat, 22 Dec 2012 13:59:23 +0000 Received: by mail-ie0-f172.google.com with SMTP id c13so7419099ieb.17 for ; Sat, 22 Dec 2012 05:59:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=OgeS1Oktu9o88ftUaEMy0FnKNiSU/McgUCu0wN1YrPg=; b=fQorkNDMIk1kpTZaMUM9D4VKmZ5liQ3cwHz/OOY+OSV2KDYzZBWshafwSK/sGlkM+P 95wHersy5exDBAUrMne0OlEyJZKWty8Vo0f3GQ9nOGOK3e+syv0/zHhUT98rK3Lh+Ip3 Rj1yLJMfjX85qaX+ODHrDE+bqLiIczb4gDALjrenUF4WN2nQq8jGkDiraktGhAGNZe+u 6/PGzPNeZ31b4Gp15h1kqRt2HvhKH6EB3A7Jni2xgxHCuDysbPj6CaRuYg77Fmm33NAU hXm1sDuxavurL/mIe8QC4C48EZxwKSM1yru1UAxvWl5WREMUHZ0dKsgARJT63W/63mkR l4Rg== Received: by 10.50.154.227 with SMTP id vr3mr16380293igb.43.1356184761810; Sat, 22 Dec 2012 05:59:21 -0800 (PST) MIME-Version: 1.0 Received: by 10.64.48.171 with HTTP; Sat, 22 Dec 2012 05:59:01 -0800 (PST) From: Morten Hustveit Date: Sat, 22 Dec 2012 14:59:01 +0100 Message-ID: Subject: Size limit on GiST nodes not documented To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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 (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs