Re: [SQL] query with subquery abnormally slow?

From: Oskar Liljeblad <osk(at)hem(dot)passagen(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] query with subquery abnormally slow?
Date: 1999-11-01 19:05:28
Message-ID: 19991101200528.A7338@oskar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Nov 01, 1999 at 07:47:07PM +0100, Oskar Liljeblad wrote:
> I'm doing a SELECT query with a subquery on a table with 12K rows
> but it is very slow (10 seconds+). The query looks like this:

Ok, I should have read the latest FAQ and checked the mail
archive before posting this.

I've read about the EXISTS-workaround, but it seems it can't be
applied to my query because it deals with one table only.
Or can it?

Oskar Liljeblad (osk(at)hem(dot)passagen(dot)se)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Moray McConnachie 1999-11-01 19:59:20 Re: [SQL] query with subquery abnormally slow?
Previous Message Oskar Liljeblad 1999-11-01 18:47:07 query with subquery abnormally slow?