Re: Buglist - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Buglist
Date
Msg-id 2c8ckvohaof9g46iq3d46ccvtv8ikjif2l@4ax.com
Whole thread Raw
In response to Re: Buglist  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Fri, 22 Aug 2003 16:27:53 +0530, Shridhar Daithankar
<shridhar_daithankar@persistent.co.in> wrote:
>What does FSM does then?

FSM = Free Space Map.  VACUUM writes information into the FSM, INSERTs
consult the FSM to find pages with free space for new tuples.

> I was under impression that FSM stores page
>pointers and vacuum work on FSM information only. In that case, it wouldn't
>have to waste time to find out which pages to clean.

This has been discussed yesterday here and on -hackers ("Decent VACUUM
(was: Buglist)").  We were talking about inventing a second data
structure: RSM.

Servus
 Manfred

pgsql-general by date:

Previous
From: Diogo Biazus
Date:
Subject: Strange problem with PL/PgSQL stored procedures
Next
From: "scott.marlowe"
Date:
Subject: Re: Postgresql for Solaris on Sparc