On Fri, 27 Apr 2001, Mikheev, Vadim wrote:

> > > >         Row reuse without vacuum
> > >
> > > Yes, it will help to remove uncommitted rows.
> >
> > Same question as I asked Bruce ... how? :)  I wasn't trying to be
> > fascisious(sp?) when I asked, I didn't realize the two were
> > connected and am curious as to how :)
>
> After implementing UNDO operation (we have only REDO now)
> transactions will roll back their changes on abort and so
> free space occupied by inserted rows.

Ahhh, okay, so this isn't reusing space on delete/update, so much as
avoiding writing to the table until the transaction is committed?



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to