| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | HK | 2002-10-18 09:03:28 | What is postgres password. |
| Previous Message | Jules Alberts | 2002-10-18 07:07:38 | Re: char() or varchar() for frequently used column |