Re: Large database help

Поиск
Список
Период
Сортировка
От xbdelacour@yahoo.com
Тема Re: Large database help
Дата
Msg-id 5.0.2.1.0.20010423181442.019be8f0@pop.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Large database help  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@postgresql.org


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


В списке pgsql-admin по дате отправления:

Предыдущее
От: xbdelacour@yahoo.com
Дата:
Сообщение: Re: Large database help
Следующее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: Large database help