Re: Free space mapping (was Re: Multi-Versions and Vacuum) - Mailing list pgsql-general

From grant
Subject Re: Free space mapping (was Re: Multi-Versions and Vacuum)
Date
Msg-id Pine.LNX.4.33.0207191311510.29118-100000@dbms.amadensor.com
Whole thread Raw
In response to Free space mapping (was Re: Multi-Versions and Vacuum)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
So, then, even if there is an overflow of pages with free space, stepping
up the vacuum schedule may help this eventually catch up.

As for an automated way to set this up, if the FSM size cannot be adjusted
without a restart of the postmaster, then on startup, you could take a
number of pages currently with free space or a percentage of the number of
pages, which ever is greater.  The percentage could have a default, and
also be configurable.


pgsql-general by date:

Previous
From: Anthony Berglas
Date:
Subject: Re: Multi-Versions and Vacuum -- cf Oracle & Vacuum alt
Next
From: Mike Mascari
Date:
Subject: Re: Multi-Versions and Vacuum -- cf Oracle & Vacuum alt