Re: Large database help - Mailing list pgsql-admin

From Tom Lane
Subject Re: Large database help
Date
Msg-id 8370.988002473@sss.pgh.pa.us
Whole thread Raw
In response to Re: Large database help  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Large database help  (xbdelacour@yahoo.com)
List pgsql-admin
>> 27 processes: 24 sleeping, 3 running, 0 zombie, 0 stopped
>> CPU states: 16.3% user,  3.8% system,  0.0% nice, 79.8% idle
>> Mem:  517292K av, 508400K used,   8892K free,  94444K shrd, 197224K buff
>> Swap:  65988K av,      0K used,  65988K free                160740K cached

These numbers don't add up.  If there's a 384M shared-memory block
in the system, how can there be 197M of kernel disk buffers (not to
mention the kernel and user programs)?

            regards, tom lane

pgsql-admin by date:

Previous
From: Randall Perry
Date:
Subject: Re: Connecting via perl gives "root" does not exist
Next
From: lbottorff@harveycounty.com
Date:
Subject: ODBC on cygwin/NT Postgres 7.1