Re: using limit with delete

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chris Smith <chris(at)interspire(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using limit with delete
Date: 2005-04-08 12:54:34
Message-ID: 20050408125434.GA15927@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 07, 2005 at 11:51:10 +1000,
Chris Smith <chris(at)interspire(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-08 13:52:42 Re: Index use with left join
Previous Message Roman Neuhauser 2005-04-08 09:47:35 Re: How to query pgsql from a BASH script ?