Re: Bulk processing & deletion

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Ivan Voras <ivoras(at)freebsd(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Bulk processing & deletion
Date: 2011-10-13 12:37:57
Message-ID: CAJY59_gEmBEgCtmjW4DLESKBhcpkyPR_aQa2L1diKB4eUyeHgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If you don't need the data for more then a transaction, or connection
length - use temporary tables to store ids of data you need to delete.
If those change, or move, or something - it means you are missing PK
on that table.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2011-10-13 12:39:00 Re: Bulk processing & deletion
Previous Message Alban Hertroys 2011-10-13 12:34:00 Re: Bulk processing & deletion