Re: optimizing a cpu-heavy query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: optimizing a cpu-heavy query
Дата
Msg-id 14933.1303913077@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: optimizing a cpu-heavy query  (Joel Reymont <joelr1@gmail.com>)
Ответы Re: optimizing a cpu-heavy query  (Hitoshi Harada <umi.tanuki@gmail.com>)
Список pgsql-general
Joel Reymont <joelr1@gmail.com> writes:
> On Apr 26, 2011, at 5:00 PM, Tom Lane wrote:
>> For another couple orders of magnitude, convert the sub-function to C code.  (I don't think you need
>> a whole data type, just a function that does the scalar product.)

> That's a 30x speedup, from 12 minutes down to 38s. Thanks Tom!

Huh, I would've bet on a lot more actually.  The nodeFunctionscan and
nodeAgg code must not be as inefficient as it looks on the surface ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Raghavendra
Дата:
Сообщение: Re: Re: Create Database automatacally after silent installation of postgresql. ?
Следующее
От: Carlos Mennens
Дата:
Сообщение: Re: Switching Database Engines