Re: Size of Path nodes - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Size of Path nodes
Date
Msg-id 56621730.7040809@BlueTreble.com
Whole thread Raw
In response to Size of Path nodes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Size of Path nodes
List pgsql-hackers
On 12/4/15 11:50 AM, Tom Lane wrote:
> which means Robert has already blown the planner's space consumption out
> by close to a factor of 2, and I should stop worrying.  Or else he should
> start worrying.  Do we really need this field?  Did anyone pay any
> attention to what happened to planner space consumption and performance
> when the parallel-scan patch went in?  Or am I just too conditioned by
> working with last-century hardware, and I should stop caring about how
> large these nodes are?

I suspect Cachegrind[1] would answer a lot of these questions (though 
I've never actually used it). I can't get postgres to run under valgrind 
on my laptop, but maybe someone that's been successful at valgrind can 
try cachegrind (It's just another mode of valgrind).

[1] http://valgrind.org/docs/manual/cg-manual.html
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Bill Moran
Date:
Subject: Re: remapped localhost causes connections to localhost to fail using Postgres
Next
From: Peter Geoghegan
Date:
Subject: Re: Size of Path nodes