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

Re: Delete performance

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Delete performance
Date: 2009-06-14 16:12:50
Message-ID: 4A352182.30201@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
Jana wrote:
> 
> Hello,
> i have a table with about 250m records from which i want to delete 
> thoose not contained in other table. I used this SQL query:
> DELETE FROM data_structures_items WHERE id_data_structure NOT IN (
> SELECT id_structure FROM data_structures);


DELETE FROM data_structures_items, data_structures WHERE 
data_structures_items.id_data_structure = 
data_structures.id_data_structure AND 
data_structures_items.id_data_structure IS NULL;

In response to

Responses

pgsql-novice by date

Next:From: Frank BaxDate: 2009-06-14 17:21:36
Subject: Re: Delete performance
Previous:From: JanaDate: 2009-06-14 13:36:34
Subject: Delete performance

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