Re: Massive memory use for star query

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Mark Kirkwood" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Massive memory use for star query
Date: 2011-04-15 15:14:36
Message-ID: 4DA81A8C020000250003C894@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)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

Attachment Content-Type Size
vmstat-during-explain.txt text/plain 2.6 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-04-15 16:43:01 Re: Massive memory use for star query
Previous Message Kevin Grittner 2011-04-15 13:59:14 Re: Massive memory use for star query