Hello 2010/4/7 paulo matadr <saddon...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
