can one speed up a custom aggregate by using native ones

From: "Rhys A(dot)D(dot) Stewart" <rhys(dot)stewart(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: can one speed up a custom aggregate by using native ones
Date: 2012-12-18 19:31:42
Message-ID: CACg0vTmMNFoHKdSLatYesj2rs=HmKVWuf_ToVXinE21VJWP-8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I have an aggregate function which basically concatenates a whole bunch of
rows (that would be the sfunc) and then wraps it in a header and footer
(the finalunc). It is however for fairly large set many orders of magnitude
slower than running string_agg and then the finalfunc.

Is there anyway to use the builtin functions say in the aggregate function
definition. Or any other way to speed them up?

Regards,

Rhys
Peace & Love|Live Long & Prosper

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-12-18 21:18:41 Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1
Previous Message Steve Crawford 2012-12-18 17:53:10 Re: data type - import problem