Skip site navigation (1) Skip section navigation (2)

psql/postmaster not freeing up resources? (based on "top" command)

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: psql/postmaster not freeing up resources? (based on "top" command)
Date: 2002-10-18 08:43:34
Message-ID: 20021018084334.47784.qmail@web80302.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi:

   I was monitoring the time to perform  a complicated
query in psql using "top" command with "s 1" switch.
So the screen is always refreshed after 1 second.

   Initially the following state of the psql/postmster
before I started the query

Size  RSS   Share  State %CPU  %Mem  time Command
3872  3872  3368     S    0    .1    0.0  postmaster

Sometime after the query has finished executing."top"
reported the following state

Size   RSS   Share  State %CPU  %Mem  time  command
11724  11M   11072   S     0    .5    4:27  postmaster

  Isn't it suppose to revert back to its orginal state
after the query? I tried to execute a query on a very
small table to see if the settings would change, yet
the settings does not change.

    Any idea on this phenomemon?

thank you in advance,
ludwig

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

Responses

pgsql-novice by date

Next:From: HKDate: 2002-10-18 09:03:28
Subject: What is postgres password.
Previous:From: Jules AlbertsDate: 2002-10-18 07:07:38
Subject: Re: char() or varchar() for frequently used column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group