Re: count with high allocation

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Cc: GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Re: count with high allocation
Date: 2010-04-07 14:27:35
Message-ID: w2idcc563d11004070727s221d674dw722cac521ec1e87f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 7, 2010 at 8:11 AM, paulo matadr <saddoness(at)yahoo(dot)com(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-07 14:31:27 Re: count with high allocation
Previous Message Pavel Stehule 2010-04-07 14:26:13 Re: count with high allocation