Re: array_accum aggregate - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: array_accum aggregate
Date
Msg-id 20061006220650.GL24675@kenobi.snowman.net
Whole thread Raw
In response to array_accum aggregate  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
* Stephen Frost (sfrost@snowman.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

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: array_accum aggregate
Next
From: Josh Berkus
Date:
Subject: Re: pg_upgrade: downgradebility