Lists (In) performance

From: "Marcus Vinicius" <marcusv(dot)listas(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Lists (In) performance
Date: 2006-09-06 12:45:16
Message-ID: 9f394b1c0609060545v3962f369g22180ca5f4975092@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Is the use of lists "Where field IN ('A',...'Z')" faster than using
multiple conditions like "Where field = 'A' OR .... field = 'Z'" ? In
every situation ? Depends on what ?

Note: (I guess im mistaken, but i remeber seeing that at the pgsql
manual somewhere)

Thanks

Marcus

Browse pgsql-performance by date

  From Date Subject
Next Message Nimesh Satam 2006-09-07 10:31:34 Template0 age is increasing speedily.
Previous Message Dave Cramer 2006-09-05 18:12:46 Re: increasing shared buffers: how much should be removed