Re: Automatic free space map filling

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Automatic free space map filling
Date: 2006-03-01 16:32:12
Message-ID: 11395.1141230732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> I'm not sure if I made myself clear. The idea is that you fill the free-space
> map early with opportunitistic entries in the hope that most updates and
> deletes go through "soon". That is, these entries will be invalid for a
> short time but hopefully by the time another write looks at them, the entries
> will have become valid. That way you don't actually have to run vacuum on
> these deleted rows.

How does an optimistic FSM entry avoid the need to run vacuum? All that
will happen is that some backend will visit the page and not find usable
free space.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2006-03-01 16:39:42 8.2 Feature Freeze Rough Estimate
Previous Message Tom Lane 2006-03-01 16:30:10 Re: [ADMIN] Reg:lo_open error..pls help me