Re: Improving a simple query? - Mailing list pgsql-performance

From nolan@celery.tssi.com
Subject Re: Improving a simple query?
Date
Msg-id 20030713195440.15746.qmail@celery.tssi.com
Whole thread Raw
In response to Improving a simple query?  (Steve Wampler <swampler@noao.edu>)
List pgsql-performance
>  select * from attributes_table where id in (select id from
>       attributes where (name='obsid') and (value='oid00066'));

Can you convert it into a join?  'where in' clauses tend to slow pgsql
down.
--
Mike Nolan

pgsql-performance by date:

Previous
From: "Balazs Wellisch"
Date:
Subject: Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
Next
From: "Balazs Wellisch"
Date:
Subject: Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL