Re: Deleting orphaned records (not exists is very slow)

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deleting orphaned records (not exists is very slow)
Date: 2010-09-27 15:16:12
Message-ID: AANLkTik2D5VX_SDgmem2WzsZ6xp6Cdd4DZ0XzP9a8kvE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

prior to 8.4 not in will be slow. Just use left join.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Hirt 2010-09-27 17:39:16 pg_upgrade
Previous Message Dimitri Fontaine 2010-09-27 14:54:21 Re: Visualize GiST Index