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,
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
pgsql-novice by date
|Next:||From: HK||Date: 2002-10-18 09:03:28|
|Subject: What is postgres password.|
|Previous:||From: Jules Alberts||Date: 2002-10-18 07:07:38|
|Subject: Re: char() or varchar() for frequently used column|