Postgres Pro
Downloads
Home   >   mailing lists

Re: simple left join slows query more than expected - Mailing list pgsql-performance

From Tom Lane
Subject Re: simple left join slows query more than expected
Date
Msg-id 29109.1070042138@sss.pgh.pa.us
Whole thread Raw
In response to simple left join slows query more than expected  (Jonathan Knopp <jknopp@delegated.net>)
List pgsql-performance
Tree view 
Jonathan Knopp <jknopp@delegated.net> writes:
> I'v spent a couple days playing with this problem and searching the mailing lists and
> docs etc but come up with nothing. Any help would be much appreciated.

Don't use inheritance to define the contacts table.

            regards, tom lane

pgsql-performance by date:

Previous
From: Jonathan Knopp
Date:
Subject: simple left join slows query more than expected
Next
From: Tom Lane
Date:
Subject: Re: duration logging setting in 7.4