Re: FW: Chunk Delete - Mailing list pgsql-general

From Alexander Staubo
Subject Re: FW: Chunk Delete
Date
Msg-id 88daf38c0711150514p1efe9cbbl2c0b1fbb20512fde@mail.gmail.com
Whole thread Raw
List pgsql-general
[Reposting accidental private response to list]

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

You add pgsql-general@postgresql.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.

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Chunk Delete
Next
From: "Abraham, Danny"
Date:
Subject: Re: Chunk Delete