Re: Massive memory use for star query

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Massive memory use for star query
Дата
Msg-id 4DA808E2020000250003C881@gw.wicourts.gov
обсуждение исходный текст
Ответ на Massive memory use for star query  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: Massive memory use for star query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Massive memory use for star query  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-bugs
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:

kgrittn@kgrittn-desktop:~/work/starjoin$ ./gendata.pl
generate cat
cannot open cat.dat: No such file or directory at ./gendata.pl line
17.

> Here's what a ps listing looks like:
>
> VSZ         RSS         SZ        CMD
> 1849524 1793680 1791144 postgres: postgres test [local] EXPLAIN

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

-Kevin

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: BUG #5981: Attempt to install language pltcl fails on 64-bit installation
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Massive memory use for star query