Re: Enhancement Request

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Enhancement Request
Дата
Msg-id CANzqJaAKMAHvNv9hTW=b8yVS_88WyS6kvOwzxdDgmqa=4M29sQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Enhancement Request  ("Hajek, Nick" <Nick.Hajek@vishay.com>)
Ответы Re: Enhancement Request
Список pgsql-admin
On Wed, Jan 31, 2024 at 3:51 PM Hajek, Nick <Nick.Hajek@vishay.com> wrote: 
 [snip]

 Delete from table1 where table1.id in (select table1.id from table1 limit yourlimitnumber)


The IN predicate is only efficient for a very small number of elements, supported by an index.  People (including me) who would find DELETE FROM .. LIMIT TO ... useful want to delete a *lot* of rows (but not all in one giant statement).

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Enhancement Request
Следующее
От: Rajesh Kumar
Дата:
Сообщение: Basebackup command