| 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: | Whole Thread | Raw Message | 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
| 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 |