From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PERFORM] Hash Anti Join performance degradation |
Date: | 2011-06-01 21:53:15 |
Message-ID: | 20110601215315.GC14215@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
On Wed, Jun 01, 2011 at 04:58:36PM -0400, Robert Haas wrote:
> On Wed, Jun 1, 2011 at 4:47 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> >> I guess the real issue here is that m1.id < m2.id has to be evaluated
> >> as a filter condition rather than a join qual.
> >
> > Well, if you can invent an optimized join technique that works for
> > inequalities, go for it ... but I think you should get at least a
> > PhD thesis out of that.
>
> Sounds good, except that so far NOT getting a PhD seems like a much
> better financial prospect. :-)
Yeah, last time I heard of some Uni being so impressed by independent
work that they just sort of handed out a Ph.D. it involved a Swiss
patent clerk ...
Ross
--
Ross Reedstrom, Ph.D. reedstrm(at)rice(dot)edu
Systems Engineer & Admin, Research Scientist phone: 713-348-6166
Connexions http://cnx.org fax: 713-348-3665
Rice University MS-375, Houston, TX 77005
GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2011-06-01 21:55:46 | Re: pg_terminate_backend and pg_cancel_backend by not administrator user |
Previous Message | Jaime Casanova | 2011-06-01 21:27:48 | Re: Bad UI design: pg_ctl and data_directory |
From | Date | Subject | |
---|---|---|---|
Next Message | CS DBA | 2011-06-01 22:26:57 | Re: Problem query |
Previous Message | Kevin Grittner | 2011-06-01 21:38:16 | Re: Problem query |