Skip site navigation (1) Skip section navigation (2)

Re: GiST index performance

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: GiST index performance
Date: 2010-02-25 23:42:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Was there every any conclusion on this issue?


Matthew Wakeling wrote:
> Revisiting the thread a month back or so, I'm still investigating 
> performance problems with GiST indexes in Postgres.
> Looking at 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 affected 
> 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 
> for 
> 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 willing 
> to do some investigation to try and solve it.
> Do you have a recommendation for how to go about profiling Postgres, what 
> profiler to use, etc? I'm running on Debian Linux x86_64.
> Matthew
> -- 
>  Jadzia: Don't forget the 34th rule of acquisition: Peace is good for business.
>  Quark:  That's the 35th.
>  Jadzia: Oh yes, that's right. What's the 34th again?
>  Quark:  War is good for business. It's easy to get them mixed up.
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:

  Bruce Momjian  <bruce(at)momjian(dot)us>
  PG East:
  + If your life is a hard drive, Christ can be your backup. +

In response to


pgsql-performance by date

Next:From: Bruce MomjianDate: 2010-02-25 23:44:02
Subject: Re: GiST index performance
Previous:From: Yu-Ju HongDate: 2010-02-25 23:29:42
Subject: Re: dbt2 performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group