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.