Re: Massive memory use for star query

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Massive memory use for star query
Дата
Msg-id 4DA81A8C020000250003C894@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Massive memory use for star query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-bugs
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
> Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:
>
>> Here's a simplified example using synthetic data (see attached to
>> generate if desired):
>
> Doesn't work for me:

Edited scripts to change hard-coded directory.  Issue confirmed.

> If you run pmap -d on the pid, what does the last line look like?

$ pmap -d 5869|grep '^mapped' ; ps aux|grep '^kgrittn   5869 '
mapped: 1132044K    writeable/private: 1084480K    shared: 38436K
kgrittn   5869  101 35.4 1139664 1094784 ?     Rs   10:01   0:20
postgres: kgrittn test [local] EXPLAIN

This wasn't necessarily at the peak.  Attached is `vmstat 1` output
during the EXPLAIN.  About 1.1 GB private writeable memory consumed
on my HEAD build on kubuntu 32 bit.

-Kevin


Вложения

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Massive memory use for star query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Massive memory use for star query