Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group