On Mon, Nov 30, 2009 at 11:53 AM, Jaime Casanova <jcasa...@systemguards.com.ec> wrote: > 2009/11/30 Jaime Casanova <jcasa...@systemguards.com.ec>: >> Hi, >> >> why we can't do $subject? it could have any benefit on the planner? >> > > seems like while we can set the cost of the state transition function, > that cost is not propagated...
I thought for sure you must be wrong about this, but I just read the source code and, sure enough, the cost of the transition and final functions are totally ignored. In fact, there's a comment about this in cost_agg(): * Note: ideally we should use the pg_proc.procost costs of each * aggregate's component functions, but for now that seems like an * excessive amount of work. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers