Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with hash join over nested loop - Mailing list pgsql-performance

From Tom Lane
Subject Re: Problems with hash join over nested loop
Date
Msg-id 8314.1383078998@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with hash join over nested loop  (Jim Nasby <jnasby@enova.com>)
Responses Re: Problems with hash join over nested loop  (Jim Nasby <jnasby@enova.com>)
List pgsql-performance
Tree view 
Jim Nasby <jnasby@enova.com> writes:
> Is there a way to measure memory consumption during planning, short of something like strace? (I've got no dev tools
availableon our servers.) 

Nothing built-in, I'm pretty sure.  You could probably add some
instrumentation, but that would require running modified executables ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Problems with hash join over nested loop
Next
From: Ben Hoyt
Date:
Subject: Adding foreign key constraint holds exclusive lock for too long (on production database)