Skip site navigation (1) Skip section navigation (2)

Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Guy Fraser <guy(at)incentre(dot)net>
Cc: Philipp Buehler <pb(at)de(dot)buehler(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly
Date: 2004-04-26 19:46:45
Message-ID: 20040426194645.GB3658@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, Apr 26, 2004 at 12:53:09PM -0600, Guy Fraser wrote:

> Eventually the automatic purging of  'stale' data will be supported,
> but hopefully it will be configurable to allow 'time travel' when
> required, and allow for a reasonable time to be able to roll back
> transactions.

Well, you are saying two different things here: to garbage-collect
automatically the database (rather than by manual VACUUMs), and to be
able to UNDO transactions, effectively going back in time.

The former is likely to be supported in some not-too-distant future,
maybe hopefully the next release; the latter is not even planned, and in
the past it has been disregarded as too costly.  Not implementation
time cost, mind you, but runtime cost.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)

In response to

Responses

pgsql-general by date

Next:From: Dann CorbitDate: 2004-04-26 19:48:45
Subject: Re: Arbitrary precision modulo operation
Previous:From: Timothy PerrigoDate: 2004-04-26 19:12:14
Subject: questions on rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group