Re: using limit with delete - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: using limit with delete
Date
Msg-id 20050408125434.GA15927@wolff.to
Whole thread Raw
In response to using limit with delete  (Chris Smith <chris@interspire.com>)
List 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 by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: How to query pgsql from a BASH script ?
Next
From: Tom Lane
Date:
Subject: Re: Index use with left join