Re: Partial commit within the trasaction

Поиск
Список
Период
Сортировка
От Bohdan Linda
Тема Re: Partial commit within the trasaction
Дата
Msg-id 20050908153540.GA15914@bafster.chello.upc.cz
обсуждение исходный текст
Ответ на Re: Partial commit within the trasaction  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: Partial commit within the trasaction  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
On Thu, Sep 08, 2005 at 04:35:51PM +0200, Michael Fuhr wrote:
> On Thu, Sep 08, 2005 at 03:39:50PM +0200, Bohdan Linda wrote:
> commit it now."  You have to do some extra bookkeeping and you can't
> commit several prepared transactions atomically (as far as I know),
> but that's one way you could make changes durable without actually
> committing them until later.

In case of durable transactions, would they be released from memory? Thus
could the transaction be more respectfull to the HW when processing too
much data?

And what about nested transactions? Are they planned? The point is
connected to my previous question of the secured access to stored
procedures. If I move part of database logic to the client, I will have to
introduce parameters to the procedures. This may be potentialy abusable.

If I try to use dblink from server to server (both are the same), is there
some perfromance penalty? How big?

Regards,
Bohdan

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect