Обсуждение: Re: FW: Chunk Delete

Поиск
Список
Период
Сортировка

Re: FW: Chunk Delete

От
"Alexander Staubo"
Дата:
[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.