Re: FW: Chunk Delete

From: "Alexander Staubo" <alex(at)purefiction(dot)net>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: FW: Chunk Delete
Date: 2007-11-15 13:14:49
Message-ID: 88daf38c0711150514p1efe9cbbl2c0b1fbb20512fde@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[Reposting accidental private response to list]

On 11/15/07, Abraham, Danny <danny_abraham(at)bmc(dot)com> wrote:
> How do I add a note to a thread?

You add pgsql-general(at)postgresql(dot)org to To: or Cc:. Your mail program
probably has a "Reply to all" button that will accomplish this.

> THE problem is that the table does not have a primary key; Too expensive.

How many attributes? If they're not too many, you could do:

delete from foo where (a, b) in (select a, b from foo order by a limit 50000);

I take it you want to delete a specific subset of rows, not just random ones?

Alexander.

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2007-11-15 13:33:04 Re: Chunk Delete
Previous Message Andrew Sullivan 2007-11-15 13:13:38 Re: Chunk Delete