Re: Massive memory use for star query - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: Massive memory use for star query
Date
Msg-id 4DA81A8C020000250003C894@gw.wicourts.gov
Whole thread Raw
In response to Re: Massive memory use for star query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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


Attachment

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Massive memory use for star query
Next
From: Tom Lane
Date:
Subject: Re: Massive memory use for star query