Skip site navigation (1) Skip section navigation (2)

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 13:59:14
Message-ID: 4DA808E2020000250003C881@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
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:
 
kgrittn(at)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

In response to

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2011-04-15 15:14:36
Subject: Re: Massive memory use for star query
Previous:From: Dave PageDate: 2011-04-15 08:51:44
Subject: Re: BUG #5981: Attempt to install language pltcl fails on 64-bit installation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group