problem when optimizing the window aggregation

Поиск
Список
Период
Сортировка
Искать
От
Wang, Chaoyong
Тема
problem when optimizing the window aggregation
Дата
Msg-id
95FA8B25DB5E2D4E889EB9BEB6A6406F3CADFF@CORPUSMX30B.corp.emc.com
Список
Дерево обсуждения
problem when optimizing the window aggregation "Wang, Chaoyong" <Chaoyong.Wang@emc.com>
Re: problem when optimizing the window aggregation Tom Lane <tgl@sss.pgh.pa.us>
Re: problem when optimizing the window aggregation "Wang, Chaoyong" <Chaoyong.Wang@emc.com>

Hi,

 

I’m trying to reduce the re-computing of window aggregation. Here the AVG function for example.

 

The original window aggregation’s transition value(transValue) of AVG is an ArrayType, that contains two main values(sum, count).

 

Now, I’m using a temporary transition value (tempTransValue), and I need to copy tempTransValue to transValue.

 

I used the function datumCopy as following:

peraggstate->transValue = datumCopy(peraggstate->tempTransValue, peraggstate->transtypeByVal, peraggstate->transtypeLen);

 

But when the copied transValue is passed to the invoke function, here is int4_avg_accum, the ArrayType returned from PG_GETARG_ARRAYTYPE_P(0) is null.

Which means the copy action is failed.

 

Anybody know why? Or give me some suggestions? Thanks very much.

 

 

Best Regards

Chaoyong Wang

 

В списке pgsql-hackers по дате отправления
От: Tatsuo Ishii
Дата:
Сообщение: Re: multi-master pgbench?
От: Tatsuo Ishii
Дата:
Сообщение: Re: multi-master pgbench?
FAQ