Hello
2010/4/7 paulo matadr <saddoness@yahoo.com.br>:
> Hi all,
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
>
> select count(field) from big_table 1 inner join big_table2...
>
> There is the possibility of using another function with less memory
> allocation?
> Is there a way to limit the memory usage of the count?
probably you have unactualised statistic. What is result of EXPLAIN
ANALYZE select count(... ?
I think, so planner uses hash arrays
try to
set enable_hashagg to off;
and again SELECT ...
Regards
Pavel Stehule
>
>
>
> Paul
>
>
> ________________________________
> Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 -
> Celebridades - Música - Esportes
