Re: Large database help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: xbdelacour(at)yahoo(dot)com, Ragnar Kjørstad <postgres(at)ragnark(dot)vestdata(dot)no>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Large database help
Date: 2001-04-23 05:07:53
Message-ID: 8370.988002473@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message lbottorff 2001-04-23 15:32:00 ODBC on cygwin/NT Postgres 7.1
Previous Message Randall Perry 2001-04-23 04:38:09 Re: Connecting via perl gives "root" does not exist