Home > mailing lists

count with high allocation - Mailing list pgsql-general

From	paulo matadr
Subject	count with high allocation
Date	April 7, 2010 11:11:55
Msg-id	497357.69364.qm@web52502.mail.re2.yahoo.com Whole thread Raw
Responses	Re: count with high allocation Re: count with high allocation Re: count with high allocation
List	pgsql-general

Tree view

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?

Paul

Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes

pgsql-general by date:

From: Merlin Moncure
Date: 07 April 2010, 10:43:38
Subject: Re: cursors from pl/pgsql

From: Sim Zacks
Date: 07 April 2010, 11:14:35
Subject: Re: default grant

count with high allocation - Mailing list pgsql-general

Previous

Next