Re: GiST index performance

От: Matthew Wakeling
Тема: Re: GiST index performance
Дата: ,
Msg-id: alpine.DEB.2.00.0906111334200.4337@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: Re: GiST index performance  (Tom Lane)
Ответы: Re: GiST index performance  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

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 по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: GiST index performance
От: Erik Aronesty
Дата:
Сообщение: Re: Best way to load test a postgresql server