Re: simple left join slows query more than expected

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Knopp <jknopp(at)delegated(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: simple left join slows query more than expected
Date: 2003-11-28 17:55:38
Message-ID: 29109.1070042138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jonathan Knopp <jknopp(at)delegated(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steve Atkins 2003-11-28 20:37:00 Re: For full text indexing, which is better, tsearch2 or
Previous Message Jonathan Knopp 2003-11-28 05:58:29 simple left join slows query more than expected