Postgres Pro
Downloads
Home   >   mailing lists

Re: GroupAggregate and Integer Arrays - Mailing list pgsql-performance

From Jeff Janes
Subject Re: GroupAggregate and Integer Arrays
Date
Msg-id CAMkU=1wS2ioBvb67zbqdu7TnH=-_x+3c9s88icrjWqts2_hBUA@mail.gmail.com
Whole thread Raw
In response to GroupAggregate and Integer Arrays  (David Osborne <david@qcode.co.uk>)
Responses Re: GroupAggregate and Integer Arrays
List pgsql-performance
Tree view
On Fri, Oct 23, 2015 at 7:29 AM, David Osborne <david@qcode.co.uk> wrote:
 
Hi,

Wondering if anyone could suggest how we could improve the performance of this type of query?
The intensive part is the summing of integer arrays as far as I can see.


Postgres does not ship with any 'sum' function which takes array arguments.

> select sum('{1,2,3,4,5,6}'::int[]);

ERROR:  function sum(integer[]) does not exist

Are you using a user defined function?  If so, how did you define it?

Cheers,

Jeff

pgsql-performance by date:

Previous
From: David Osborne
Date:
Subject: GroupAggregate and Integer Arrays
Next
From: David Osborne
Date:
Subject: Re: GroupAggregate and Integer Arrays