Re: RE: Re: [ADMIN] v7.1b4 bad performance

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: RE: Re: [ADMIN] v7.1b4 bad performance
Дата
Msg-id 3A967B05.9030609@tm.ee
обсуждение исходный текст
Список pgsql-hackers
Vadim Mikheev wrote:

>> Should this kind of usage be replaced in the future by 
>> having backend id as a key and then doing delete by that 
>> key in the end ?
> 
> 
> Isn't it what we have right now?

I meant doing it at the application level, not what backend does internally.

Like we are supposed to implement time-travel now that it is (mostly) 
gone from core functionality :c)

> But I believe that in future we must remove
> modifications made by aborted transactions
> immediately, without keeping them till vacuum.
> So - yes: rollback of read-write transactions
> will take longer time.

but will

INSERT-DELETE-COMMIT
take longer than

INSERT-ABORT

?

----------------
Hannu



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

Предыдущее
От: "Rod Taylor"
Дата:
Сообщение: Permissions on SERIAL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Lock structures