Re: GiST index performance

From: Matthew Wakeling
Subject: Re: GiST index performance
Date: ,
Msg-id: alpine.DEB.2.00.0906111334200.4337@aragorn.flymine.org
(view: Whole thread, Raw)
In response to: Re: GiST index performance  (Tom Lane)
Responses: Re: GiST index performance  (Tom Lane)
List: pgsql-performance

Tree view

GiST index performance  (Matthew Wakeling, )
 Re: GiST index performance  (Robert Haas, )
  Re: GiST index performance  (Matthew Wakeling, )
   Re: GiST index performance  (Tom Lane, )
    Re: GiST index performance  (Matthew Wakeling, )
     Re: GiST index performance  (Tom Lane, )
      Re: GiST index performance  (Matthew Wakeling, )
       Re: GiST index performance  (Tom Lane, )
        Re: GiST index performance  (Matthew Wakeling, )
         Re: GiST index performance  (Matthew Wakeling, )
          Re: GiST index performance  (Matthew Wakeling, )
           Re: GiST index performance  (Tom Lane, )
           Re: GiST index performance  (Adam Gundy, )
        Re: GiST index performance  (Heikki Linnakangas, )
      Re: GiST index performance  (Greg Smith, )
       Re: GiST index performance  (Robert Haas, )
 Re: GiST index performance  (Bruce Momjian, )
  Re: GiST index performance  (Robert Haas, )
  Re: GiST index performance  (Matthew Wakeling, )
   Re: GiST index performance  (Robert Haas, )
   Re: GiST index performance  (Yeb Havinga, )
    Re: GiST index performance  (Yeb Havinga, )
     Re: GiST index performance  (Yeb Havinga, )
      Re: GiST index performance  (Yeb Havinga, )
       Re: GiST index performance  (Yeb Havinga, )
        Re: GiST index performance  (Kenneth Marshall, )
         Re: GiST index performance  (Yeb Havinga, )
          Re: GiST index performance  (Matthew Wakeling, )
           Re: GiST index performance  (Yeb Havinga, )
            Re: GiST index performance  (Matthew Wakeling, )

On Wed, 10 Jun 2009, Tom Lane wrote:
>> Also, no calls to anything including "bioseg"
>> in the name are recorded, although they are definitely called as the GiST
>> support functions for that data type.
>
> I have never had any success in getting gprof to profile functions that
> are in loadable libraries, which of course is exactly what you need to do
> here.

That sucks. However, as another observation, no calls to "gistfindnext"
are recorded in the profile either, and that's in the same source file as
"gistnext" which is recorded. Could it have been inlined? Shouldn't
inlining be switched off on a profiling build?

> ...the best bet is probably to make a test build of Postgres in which
> your functions are linked directly into the main postgres executable.

I'll give that a try. Oprofile scares me with the sheer number of options.

Matthew

--
 Prolog doesn't have enough parentheses. -- Computer Science Lecturer


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: GiST index performance
From: Erik Aronesty
Date:
Subject: Re: Best way to load test a postgresql server