Postgres Pro
Downloads
Home   >   mailing lists

Re: Select with qualified join condition / Batch inserts - Mailing list pgsql-performance

From Matt Clark
Subject Re: Select with qualified join condition / Batch inserts
Date
Msg-id 001e01c4b2a2$d82b77f0$8300a8c0@solent
Whole thread Raw
In response to Select with qualified join condition / Batch inserts  (Bernd <bernd_pg@genedata.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Bernd
Date:
Subject: Select with qualified join condition / Batch inserts
Next
From: "Leeuw van der, Tim"
Date:
Subject: Re: Select with qualified join condition / Batch inserts