Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group