otal runtime: 485.638 ms
(9 rows)
On Mar 21, 2011, at 1:54 AM, Pavel Stehule wrote:
> Hello
>
> I think so HashAggregate goes out of memory - you can try to increase
> a work_mem.
>
> There are better queries for counting duplicit then cross join
>
> Regards
>
>
1053.523 ms
(8 rows)
Time: 1054.864 ms
On Mar 20, 2011, at 2:51 AM, Pavel Stehule wrote:
> Hello
>
> 2011/3/20 Adam Tistler :
>> I have noticed that SELECT ... = ANY(ARRAY(...)) is about twice as fast as
>> SELECT IN ( ... ).
>> Can anyone explain a reason for this
I have noticed that SELECT ... = ANY(ARRAY(...)) is about twice as fast as
SELECT IN ( ... ).
Can anyone explain a reason for this? Results are the bottom and are
reproducible. I can test with other versions if that is necessary.
./configure --prefix=/usr/local/pgsql84 --with-openssl --with-p
