Re: Heavy postgres process

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Heavy postgres process
Дата
Msg-id dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Heavy postgres process  ("Guido Barosio" <gbarosio@gmail.com>)
Список pgsql-admin
On Tue, Sep 16, 2008 at 8:37 AM, Guido Barosio <gbarosio@gmail.com> wrote:
> On Tue, Sep 16, 2008 at 1:41 AM, Vivek_Sharan <Vivek_Sharan@infosys.com> wrote:
>> Thanks for the information so far

OK, I'm not BSD expert (Tom Lane might help out here) but I'm guessing
that what we see in the following lines of top:

>> 87340 postgres    2   0  7200K  1224K select 0   1:41  0.00%  0.00% postgres
>> 90961 postgres    2   0 83580K 76008K sbwait 0   0:30  0.00%  0.00% postgres
>> 90920 postgres    2   0 83636K 76068K sbwait 0   0:29  0.00%  0.00% postgres

Is that the number on the left, like 83636K is the total memory used,
and the number to the right 76068K is how much is shared buffers
etc...  which would mean that each of those processes above are using
about 7 megs a piece, and the rest is repeated.

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Help request: how to tune performance?
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Setting Effective Cache Size