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

Поиск
Список
Период
Сортировка
От Philipp Buehler
Тема Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly
Дата
Msg-id 20040426190428.GA21592@srv9.de.buehler.net
обсуждение исходный текст
Ответ на Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly  (Guy Fraser <guy@incentre.net>)
Список pgsql-general
On 26/04/2004, Guy Fraser <guy@incentre.net> wrote To Philipp Buehler:
> What if your not the only person accessing the database and someone else
> has an active transaction that was initiated before your transaction was
> committed?

There are row locks for a reason, too?

OTOH that's somewhat like handling a filesystem. if you have
a refcount=x. Just decrease the refcount for completed
transaction and after it this count drops to 0 the tuple can be purged.

> 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.

Hm well. a comitted transaction is one, right? I dont get your
time travel here now.. hmm.

Ciao
--
Philipp Buehler, aka fips | <double-p>

cvs -d /dev/myself commit -m "it's my life" dont/you/forget

В списке pgsql-general по дате отправления:

Предыдущее
От: Timothy Perrigo
Дата:
Сообщение: questions on rules
Следующее
От: Paul Tillotson
Дата:
Сообщение: Re: Arbitrary precision modulo operation