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

Re: Large database help

From: xbdelacour(at)yahoo(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large database help
Date: 2001-04-23 22:18:04
Message-ID: 5.0.2.1.0.20010423181442.019be8f0@pop.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
I'm trying to figure that out myself :-)

According to the strace info I sent in my last message, it is in fact 
creating a 381MB shmem block.. which makes no sense, I agree.

-Xavier

At 01:07 AM 4/23/01 -0400, Tom Lane wrote:
> >> 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
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


In response to

pgsql-admin by date

Next:From: Ragnar KjørstadDate: 2001-04-24 00:06:26
Subject: Re: Large database help
Previous:From: xbdelacourDate: 2001-04-23 22:13:38
Subject: Re: Large database help

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