Re: Predicate migration on complex self joins - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Predicate migration on complex self joins
Date
Msg-id 26647.1247507362@sss.pgh.pa.us
Whole thread Raw
In response to Re: Predicate migration on complex self joins  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Predicate migration on complex self joins
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Simon Riggs <simon@2ndQuadrant.com> wrote:
>> select count(*) 
>> from foo1 a, foo1 b 
>> where a.c1 = b.c1 /* PK join */
> We had to do something like that to get acceptable performance from
> Sybase ASE.

Writing a join for a single-table query?  Why, in heavens name?
(Or have you mercifully blotted the details from your memory?)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Predicate migration on complex self joins
Next
From: "Kevin Grittner"
Date:
Subject: Re: Index-only scans