| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Jeffrey Hood <jhood(at)hmcon(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Query Performance... |
| Date: | 2002-07-18 12:10:46 |
| Message-ID: | 20020718221046.B7652@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ralph Graulich | 2002-07-18 12:14:58 | Re: Logging SQL queries? |
| Previous Message | Martijn van Oosterhout | 2002-07-18 12:07:09 | Re: Logging SQL queries? |