Speedy query help..

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Speedy query help..
Date: 2000-04-10 20:36:03
Message-ID: 004901bfa32c$63c051e0$4100000a@venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Any ideas on how I might speed this up? I know sub-selects are seriously
slow, I'm not sure what else can be done though.

DELETE from applicants_states WHERE app_id IN (SELECT s.app_id FROM
applicants_states AS s, applicants AS a WHERE s.app_id=a.app_id AND
(a.created + '90 days') < 'now' AND a.resubmitted < '10-03-1999')

Thanks!

- Mitch

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Matlack, Brad 2000-04-10 22:37:53 Finding primary keys
Previous Message Tom Lane 2000-04-10 19:50:27 Re: How to do this in PostgreSQL?