Re: using limit with delete

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: using limit with delete
Дата
Msg-id 20050408125434.GA15927@wolff.to
обсуждение исходный текст
Ответ на using limit with delete  (Chris Smith <chris@interspire.com>)
Список pgsql-general
On Thu, Apr 07, 2005 at 11:51:10 +1000,
  Chris Smith <chris@interspire.com> wrote:
>
> Is there another way to approach this?
>
> I'm trying to delete records through a webapp and if there are 500,000
> records for example, I can't really leave the page open and expect it to
> finish...

Maybe you could use a statement timeout and schedule a batch delete if
the delete times out?

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

Предыдущее
От: Roman Neuhauser
Дата:
Сообщение: Re: How to query pgsql from a BASH script ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index use with left join