Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group