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