Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets
From:
"Robert Haas" <robertmhaas(at)gmail(dot)com>
To:
"Bryce Cutt" <pandasuit(at)gmail(dot)com>
Cc:
"Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>, "Joshua Tolley" <eggyknap(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets
Date:
2009-01-07 04:49:57
Message-ID:
603c8f070901062049t229691ccuc6b7fa7e0808a6aa@mail.gmail.com (view raw or flat )
Thread:
2008-10-20 22:42:49 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-11-01 22:41:48 from "Joshua Tolley" <eggyknap(at)gmail(dot)com>
2008-11-02 23:48:36 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-11-03 00:41:55 from "Joshua Tolley" <eggyknap(at)gmail(dot)com>
2008-11-03 01:36:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-11-03 02:34:20 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-11-05 13:19:30 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-11-05 14:48:50 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-11-05 15:20:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-11-05 15:22:42 from "Joshua Tolley" <eggyknap(at)gmail(dot)com>
2008-11-06 00:06:11 from "Bryce Cutt" <pandasuit(at)gmail(dot)com>
2008-11-06 03:11:19 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-11-06 22:33:09 from "Joshua Tolley" <eggyknap(at)gmail(dot)com>
2008-11-06 22:52:54 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-11-06 23:22:16 from "Joshua Tolley" <eggyknap(at)gmail(dot)com>
2008-11-07 00:31:15 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-11-07 00:44:56 from "Joshua Tolley" <eggyknap(at)gmail(dot)com>
2008-11-10 08:57:57 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-11-21 00:44:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-11-24 16:16:57 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-12-16 04:51:38 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-20 10:58:37 from "Bryce Cutt" <pandasuit(at)gmail(dot)com>
2008-12-22 03:25:59 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-22 14:15:58 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-12-23 07:21:22 from "Bryce Cutt" <pandasuit(at)gmail(dot)com>
2008-12-23 14:22:27 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-23 14:51:51 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-12-23 15:14:29 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-23 18:28:19 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2008-12-23 18:12:22 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-12-25 15:47:57 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-27 20:10:26 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-12-28 14:47:47 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-28 22:28:20 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2008-12-30 04:55:02 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-30 05:29:06 from "Bryce Cutt" <pandasuit(at)gmail(dot)com>
2009-01-02 04:03:06 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-07 00:12:12 from "Bryce Cutt" <pandasuit(at)gmail(dot)com>
2009-01-07 04:49:57 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-07 14:14:17 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2009-02-19 04:20:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-02-19 20:50:55 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2009-02-20 00:26:56 from David Fetter <david(at)fetter(dot)org>
2009-01-14 19:36:22 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
2009-02-19 04:28:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2008-12-18 03:53:36 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-18 05:39:16 from "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
Lists:
pgsql-hackers
> We would really appreciate help on finalizing this patch, especially in
> regard to style issues. Thank you for all the help.
Here is a cleaned-up version. I fixed a number of whitespace issues,
improved a few comments, and rearranged one set of nested if-else
statements (hopefully without breaking anything in the process).
Josh / eggyknap -
Can you rerun your performance tests with this version of the patch?
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: ITAGAKI TakahiroDate: 2009-01-07 05:09:22Subject : Re: Solve a problem of LC_TIME of windows.Previous :From : Bruce MomjianDate : 2009-01-07 04:47:14Subject : Re: Multiplexing SUGUSR1
