Re: count with high allocation - Mailing list pgsql-general

From Scott Marlowe
Subject Re: count with high allocation
Date
Msg-id w2idcc563d11004070727s221d674dw722cac521ec1e87f@mail.gmail.com
Whole thread Raw
In response to count with high allocation  (paulo matadr <saddoness@yahoo.com.br>)
List pgsql-general
On Wed, Apr 7, 2010 at 8:11 AM, paulo matadr <saddoness@yahoo.com.br> wrote:
> Hi all,
> Monitoring "top" in database server  , i could  noticed an query with
> reserved  8GB on physical memory.

You are likely seeing the SHR and VIRT columns saying that.  Lemme
guess, you've got 8G of shared memory allocated to pgsql?

If not, please show the lines from top that have you worried.

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: count with high allocation
Next
From: "Ing. Marcos Ortiz Valmaseda"
Date:
Subject: Re: default grant