Re: [PERFORM] simple left join slows query more than expected

2003-11-28 Thread Tom Lane
Jonathan Knopp [EMAIL PROTECTED] 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

[PERFORM] simple left join slows query more than expected

2003-11-27 Thread Jonathan Knopp
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. Setup is postgres 7.3.2 on redhat 7.1 on a 1.3GHz Athlon machine with 1G pc133 ram and SCSI. Here is the same query with the addition of a