Re: Improving a simple query?

From: nolan(at)celery(dot)tssi(dot)com
To: swampler(at)noao(dot)edu
Cc: pgsql-performance(at)postgresql(dot)org (Postgres-performance)
Subject: Re: Improving a simple query?
Date: 2003-07-13 19:54:40
Message-ID: 20030713195440.15746.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Balazs Wellisch 2003-07-13 20:04:48 Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
Previous Message Balazs Wellisch 2003-07-13 19:51:02 Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL