Re: Select with qualified join condition / Batch inserts

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: "'Bernd'" <bernd_pg(at)genedata(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Select with qualified join condition / Batch inserts
Date: 2004-10-15 10:36:35
Message-ID: 001e01c4b2a2$d82b77f0$8300a8c0@solent
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> SELECT cmp.WELL_INDEX, cmp.COMPOUND, con.CONCENTRATION
> FROM SCR_WELL_COMPOUND cmp, SCR_WELL_CONCENTRATION con
> WHERE cmp.BARCODE=con.BARCODE
> AND cmp.WELL_INDEX=con.WELL_INDEX
> AND cmp.MAT_ID=con.MAT_ID
> AND cmp.MAT_ID = 3
> AND cmp.BARCODE='910125864'
> AND cmp.ID_LEVEL = 1;

Quick guess - type mismatch forcing sequential scan. Try some quotes:
AND cmp.MAT_ID = '3'
AND cmp.BARCODE='910125864'
AND cmp.ID_LEVEL = '1';

M

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Leeuw van der, Tim 2004-10-15 10:44:37 Re: Select with qualified join condition / Batch inserts
Previous Message Bernd 2004-10-15 10:25:26 Select with qualified join condition / Batch inserts