Re: array_accum aggregate

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: array_accum aggregate
Date: 2006-10-06 22:06:50
Message-ID: 20061006220650.GL24675@kenobi.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Stephen Frost (sfrost(at)snowman(dot)net) wrote:
> For comparison, the new functions run with:
> time psql -c "select aaccum(generate_series) from generate_series(1,1000000);" > /dev/null
> 4.24s real 0.34s user 0.06s system
>
> Compared to:
> time psql -c "select array_accum(generate_series) from generate_series(1,1000000);" > /dev/null
> ...
>
> Well, it's still running and it's been over an hour.

Just to follow-up on this, the result was:

7601.36s real 0.36s user 0.02s system

Or about 2 hours.

Enjoy,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2006-10-07 00:18:29 Re: pg_upgrade: downgradebility
Previous Message Stephen Frost 2006-10-06 22:05:20 Re: array_accum aggregate