Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Poor memory context performance in large hash joins - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] Poor memory context performance in large hash joins
Date
Msg-id 20170224231237.rzhlpdgnkby266sc@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Poor memory context performance in large hash joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Poor memory context performance in large hash joins  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
On 2017-02-24 18:04:18 -0500, Tom Lane wrote:
> Concretely, something like the attached.  This passes regression tests
> but I've not pushed on it any harder than that.

Heh, I'd just gotten something that didn't immediately crash anymore ;)

Running your patch against Jeff's test-case, verified before that I
could easily reproduce the O(N^2) cost.

- Andres

pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: [HACKERS] Logical replication existing data copy
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Poor memory context performance in large hash joins