[GENERAL] Discerning when functions had execute revoked from public

I am trying to write something that will enumerate grants/revokes on functions to make sure they are adjusted properly after said function is drop/recreated, should that happen. This will also be used to validate that permissions are what they should be. According to: http://www.postgresql.org/

[GENERAL] aggregate functions on massive number of rows

I have an aggregate function setup (attached) that I'm calling over a massive amount of data and am running into: ERROR: cannot have more than 2^32-1 commands in a transaction CONTEXT: PL/pgSQL function "float8_jitter_add" line 16 at if error. Since I'm able to do count() and