pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Robert Haas <robertmhaas@gmail.com>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: panam <panam@gmx.net>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [PERFORM] Hash Anti Join performance degradation
Date: Tue, 31 May 2011 20:55:38 -0400
Message-ID: <BANLkTimRjbzjqA13MLtjLf1XCini_UAAQw@mail.gmail.com> (raw)
In-Reply-To: <BANLkTi==zbH2kepG3OmR=Nt0ArxMvWgwdA@mail.gmail.com>
References: <1306210464806-4420974.post@n5.nabble.com>
	<4DDB47BC.8030504@postnewspapers.com.au>
	<1306247697267-4422247.post@n5.nabble.com>
	<4DDC6109.7060708@postnewspapers.com.au>
	<1306341749094-4425890.post@n5.nabble.com>
	<4DDDBD96.4010809@postnewspapers.com.au>
	<1306413217406-4428435.post@n5.nabble.com>
	<BANLkTinwJ69W4i6JXVGqodbzZdTZ+SSzyA@mail.gmail.com>
	<BANLkTi==zbH2kepG3OmR=Nt0ArxMvWgwdA@mail.gmail.com>

On Tue, May 31, 2011 at 8:43 PM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> Yes, while here I noticed that the query was long to be killed.
> I added a CHECK_FOR_INTERRUPT() in the for(;;) loop in nodeHashjoin.c.
> It fixes the delay when trying to kill but I don't know about
> performance impact this can have in this place of the code.

Well, seems easy enough to find out: just test the query with and
without your patch (and without casserts).  If there's no measurable
difference on this query, there probably won't be one anywhere.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



view thread (35+ messages)  latest in thread

Message-ID: <BANLkTimRjbzjqA13MLtjLf1XCini_UAAQw@mail.gmail.com>
Permalink:  ../BANLkTimRjbzjqA13MLtjLf1XCini_UAAQw@mail.gmail.com/
Also on:    postgresql.org/message-id/BANLkTimRjbzjqA13MLtjLf1XCini_UAAQw@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: robertmhaas@gmail.com, cedric.villemain.debian@gmail.com, panam@gmx.net, pgsql-hackers@postgresql.org
  Subject: Re: [PERFORM] Hash Anti Join performance degradation
  In-Reply-To: <BANLkTimRjbzjqA13MLtjLf1XCini_UAAQw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox