Re: Chunk Delete

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Chunk Delete
Date: 2007-11-15 14:49:38
Message-ID: 20071115144938.GE1955@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 15, 2007 at 09:43:52AM -0500, Andrew Sullivan wrote:
> On Thu, Nov 15, 2007 at 03:33:04PM +0200, Abraham, Danny wrote:
> >
> > Based on a condition, 2,000,000 records should be deleted daily.
>
> Why not use that condition (which I presume is indexed) as the criterion for
> your delete? I mean, how else are you getting those row numbers in Oracle.

Yup, that's what I'm confused about as well.

> They have to be sorted somehow, unless you're just deleting 2million random
> records.

To be fair; they're not random, just rather arbitrarily chosen.

Sam

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-11-15 14:50:37 "global/pg_control": Permission denied
Previous Message Sam Mason 2007-11-15 14:47:22 Re: Enforcing Join condition