Re: AW: Plans for solving the VACUUM problem

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "'Mikheev, Vadim'" <vmikheev(at)SECTORBASE(dot)COM>, "'Don Baccus'" <dhogaza(at)pacifier(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: AW: Plans for solving the VACUUM problem
Date: 2001-05-28 09:11:46
Message-ID: 3B121652.C4DCE1F6@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zeugswetter Andreas SB wrote:
>
> > > You mean it is restored in session that is running the transaction ?
>
> Depends on what you mean with restored. It first reads the heap page,
> sees that it needs an older version and thus reads it from the "rollback segment".

So are whole pages stored in rollback segments or just the modified data
?

Storing whole pages could be very wasteful for tables with small records
that
are often modified.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2001-05-28 14:08:06 Re: Re: OpenOffice compile
Previous Message Martín Marqués 2001-05-28 08:07:10 Re: Re: OpenOffice compile