Re: Query Performance...

On Wed, Jul 17, 2002 at 01:31:29PM -0700, Jeffrey Hood wrote:
> We have recently converted from MS SQLServer 7 to Postgres 7.1...  The
> following query runs perfectly fine in SQL Server with any where
> clause attached, but in Postgres runs fine until you put a where
> clause that has *no* criteria for Patients... then it runs forever...
> the table sizes are approx:

EXPLAIN ANALYSE output please.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.