Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> 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.
Because the index isn't removed, right? That index thing is what usually kills us. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
