[HACKERS] Re: [HACKERS] How to hack the storage component?

2013-01-18 Thread wang chaoyong
ommit" contribution. Regards. Chaoyong Wang On Fri, Jan 18, 2013 at 5:26 PM, Heikki Linnakangas wrote: > On 18.01.2013 11:02, wang chaoyong wrote: > >> Hi folks, >> >> Currently, I'm trying to read the storage component, since it's >> biased &

[HACKERS] How to hack the storage component?

2013-01-18 Thread wang chaoyong
Hi folks, Currently, I'm trying to read the storage component, since it's biased towards the lower layer, seems more difficult to understand and debug. All the materials I have found are the original papers on http://db.cs.berkeley.edu, I'm wondering how much it have been changed since Postgre

Re: [HACKERS] problem when optimizing the window aggregation

2012-08-21 Thread Wang, Chaoyong
日 9:47 To: Wang, Chaoyong Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] problem when optimizing the window aggregation "Wang, Chaoyong" writes: > I used the function datumCopy as following: > peraggstate->transValue = datumCopy(peraggstate->tempTransValue, >

[HACKERS] problem when optimizing the window aggregation

2012-08-21 Thread Wang, Chaoyong
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 (tempTransVa