Home > mailing lists

Speedy query help.. - Mailing list pgsql-sql

From	Mitch Vincent
Subject	Speedy query help..
Date	April 10, 2000 19:33:33
Msg-id	004901bfa32c$63c051e0$4100000a@venux.net Whole thread Raw
In response to	How to do this in PostgreSQL? ("Robert Nosko" <robertn@eori.net.pl>)
Responses	Re: Speedy query help.. (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Tom Lane
Date: 10 April 2000, 18:51:32
Subject: Re: How to do this in PostgreSQL?

From: "Matlack, Brad"
Date: 10 April 2000, 21:33:32
Subject: Finding primary keys

Speedy query help.. - Mailing list pgsql-sql

Previous

Next