Re: Large database help

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