| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Shelby Cain <alyandon(at)yahoo(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: allow LIMIT in UPDATE and DELETE |
| Date: | 2006-05-23 22:15:03 |
| Message-ID: | 200605232215.k4NMF3J24585@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jim C. Nasby wrote:
> On Tue, May 23, 2006 at 10:19:25AM +0200, Csaba Nagy wrote:
> > 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.
>
> I believe it's already fixed in HEAD/8.2.
If it is, TODO doesn't reflect that:
* Make CLUSTER preserve recently-dead tuples per MVCC
requirements
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian G. Pflug | 2006-05-23 22:16:13 | Re: "make check" fails over NFS or tmpfs |
| Previous Message | Bruce Momjian | 2006-05-23 22:13:06 | Re: [GENERAL] Querying libpq compile time options |