Re: allow LIMIT in UPDATE and DELETE - Mailing list pgsql-general

From Csaba Nagy
Subject Re: allow LIMIT in UPDATE and DELETE
Date
Msg-id 1148372365.3114.5.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: allow LIMIT in UPDATE and DELETE  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: allow LIMIT in UPDATE and DELETE  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote:
> BTW, there's a bug/issue with CLUSTER that makes it not entirely
> transaction safe.

For God's sake, don't fix that one ! I rely on it... now seriously,
until there's a way to tell the DB that an exclusive lock is enough to
vacuum all dead rows, even if they would be visible by other
transactions, CLUSTER is the only thing I can use to circumvent the long
running transaction syndrome.

Cheers,
Csaba.



pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Re: Installing PostGreSQL automatically
Next
From: Csaba Nagy
Date:
Subject: Re: allow LIMIT in UPDATE and DELETE