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 <tgl@sss.pgh.pa.us>)
Ответы Re: GiST index performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Hosted servers with good DB disk performance?
Следующее
От: Shaul Dar
Дата:
Сообщение: Postgres replication: dump/restore, PITR, Slony,...?