Re: [HACKERS] Buglist - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] Buglist
Date
Msg-id 11335.1061563550@sss.pgh.pa.us
Whole thread Raw
In response to Re: Buglist  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: [HACKERS] Buglist  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: [HACKERS] Buglist  (Jan Wieck <JanWieck@Yahoo.com>)
Re: [HACKERS] Buglist  ("Matthew T. O'Connor" <matthew@zeut.net>)
Re: [HACKERS] Buglist  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
Jan Wieck <JanWieck@Yahoo.com> writes:
> Shridhar Daithankar wrote:
>> Umm.. What does FSM does then? 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.

> It's the other way around! VACUUM scan's the tables to find and reclaim
> free space and remembers that free space in the FSM.

Right.  One big question mark in my mind about these "partial vacuum"
proposals is whether they'd still allow adequate FSM information to be
maintained.  If VACUUM isn't looking at most of the pages, there's no
very good way to acquire info about where there's free space.

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Buglist
Next
From:
Date:
Subject: Re: pg_dump and alter database