From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: swapping? |
Date: | 2002-11-15 09:42:51 |
Message-ID: | B9FA721B.B89F%a.witney@sghms.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Sorry, a little OT, but anybody know the equivalent command for Mac OSX?
There doesn't seem to be a vmstat on my system
Thanks
adam
> you can use vmstat to measure swap activity. check the man page for your
> system.
>
> Robert Treat
>
> On Thu, 2002-11-14 at 10:53, Wei Weng wrote:
>> How do you notice that if a system started swapping or not?
>>
>> Thanks
>>
>> On Thu, 2002-11-14 at 09:37, Shridhar Daithankar wrote:
>>> On 14 Nov 2002 at 10:30, Wei Weng wrote:
>>>
>>>> The term had been mentioned often enough on this mailing list. Can
>>>> someone enlighten me with some description or a URL where I can read on?
>>>> And why is it important to postgresql database performace?
>>>
>>> When programs request more memory than available, OS 'swaps' some memory to
>>> special area on disk and make the memory available. To programs, it gives
>>> appearance that nearly infinite memory is available.
>>>
>>> Unfortunately disk are hell slower than RAM and hence swapping slows things
>>> down as it takes much to swap in to disk and swap out of disk. Since OS does
>>> not care which programs get swapped, it is possible that postgresql instance
>>> can get swapped. That slows down effective memory access to knees..
>>>
>>> That's why for good performance, a serve should never swap..
>>>
>>> Bye
>>> Shridhar
>>>
>>> --
>>> Peterson's Admonition: When you think you're going down for the third
time
>>> --
>>> just remember that you may have counted wrong.
>>>
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 2: you can get off all lists at once with the unregister command
>>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>> --
>> Wei Weng
>> Network Software Engineer
>> KenCast Inc.
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Henrik Steffen | 2002-11-15 10:11:06 | Re: [PERFORM] Upgrade to dual processor machine? |
Previous Message | Cedric Dufour (Cogito Ergo Soft) | 2002-11-15 08:47:23 | Re: [GENERAL] Upgrade to dual processor machine? |