Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 66EBF6329A7 for ; Tue, 2 Mar 2010 12:21:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 66870-02 for ; Tue, 2 Mar 2010 16:21:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f223.google.com (mail-fx0-f223.google.com [209.85.220.223]) by mail.postgresql.org (Postfix) with ESMTP id 3EC6A6326EF for ; Tue, 2 Mar 2010 12:21:18 -0400 (AST) Received: by fxm23 with SMTP id 23so4086fxm.3 for ; Tue, 02 Mar 2010 08:21:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=zBHHtiUIJqZvFZWX/HKWOYevMSpfSm5JOGGkGy8LoEE=; b=H9KWMepBppqO9ZaDnYrV/uQOsoZnnRodC3scuKzWXKvL1RbwWbi0V1FJL50e8eelG7 Lzpu+1SsPZJrVBzUy45pTpo1SZKkX78h+Jq+pXomVS4aWwixhWrFhrxzpgZwluGSWOA3 TQlVZLf9z35IizkVAy4MM0vuFSoSvuOt1gGek= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=eW77PVhGY6egQTMsC/noXSRUDiVUGdJLkuxQiScFCHr+ikKR1uh1vjxySbn2dqpbO3 mXIsqJ8eqLMhH3jkky/7PktzaIZd/vZ+j10/KoGM0bdyNGlZ2EJayXP8lvbvk7OF0ob5 UfC2pX69YrWjrkmIyXnL+4ltNfFpkbkDKli8I= MIME-Version: 1.0 Received: by 10.239.162.210 with SMTP id m18mr621083hbd.189.1267546876983; Tue, 02 Mar 2010 08:21:16 -0800 (PST) In-Reply-To: <201002252342.o1PNgtG07127@momjian.us> References: <201002252342.o1PNgtG07127@momjian.us> Date: Tue, 2 Mar 2010 11:21:15 -0500 Message-ID: <603c8f071003020821s55e3d7cbnf169d7866dab9f4a@mail.gmail.com> Subject: Re: GiST index performance From: Robert Haas To: Bruce Momjian Cc: Matthew Wakeling , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.481 tagged_above=-10 required=5 tests=AWL=0.118, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/19 X-Sequence-Number: 37844 On Thu, Feb 25, 2010 at 6:42 PM, Bruce Momjian wrote: > Was there every any conclusion on this issue? I don't think so. ...Robert > -------------------------------------------------------------------------= -- > > Matthew Wakeling wrote: >> >> Revisiting the thread a month back or so, I'm still investigating >> performance problems with GiST indexes in Postgres. >> >> Looking at http://wiki.postgresql.org/wiki/PostgreSQL_8.4_Open_Items I'd >> like to clarify the contrib/seg issue. Contrib/seg is vulnerable to >> pathological behaviour which is fixed by my second patch, which can be >> viewed as complete. Contrib/cube, being multi-dimensional, is not affect= ed >> to any significant degree, so should not need alteration. >> >> A second quite distinct issue is the general performance of GiST indexes >> which is also mentioned in the old thread linked from Open Items. For >> that, we have a test case at >> http://archives.postgresql.org/pgsql-performance/2009-04/msg00276.php fo= r >> btree_gist indexes. I have a similar example with the bioseg GiST index.= I >> have completely reimplemented the same algorithms in Java for algorithm >> investigation and instrumentation purposes, and it runs about a hundred >> times faster than in Postgres. I think this is a problem, and I'm willin= g >> to do some investigation to try and solve it. >> >> Do you have a recommendation for how to go about profiling Postgres, wha= t >> profiler to use, etc? I'm running on Debian Linux x86_64. >> >> Matthew >> >> -- >> =A0Jadzia: Don't forget the 34th rule of acquisition: Peace is good for = business. >> =A0Quark: =A0That's the 35th. >> =A0Jadzia: Oh yes, that's right. What's the 34th again? >> =A0Quark: =A0War is good for business. It's easy to get them mixed up. >> >> -- >> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.or= g) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-performance > > -- > =A0Bruce Momjian =A0 =A0 =A0 =A0 =A0http://momjian.us > =A0EnterpriseDB =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 h= ttp://enterprisedb.com > =A0PG East: =A0http://www.enterprisedb.com/community/nav-pg-east-2010.do > =A0+ If your life is a hard drive, Christ can be your backup. + > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org= ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >