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

From Jan Wieck
Subject Re: Free space mapping (was Re: Multi-Versions and Vacuum)
Date
Msg-id 3D387180.CDB1A0A2@Yahoo.com
Whole thread Raw
In response to Re: Free space mapping (was Re: Multi-Versions and Vacuum)  (grant <grant@amadensor.com>)
List pgsql-general
grant wrote:
>
> So, then, even if there is an overflow of pages with free space, stepping
> up the vacuum schedule may help this eventually catch up.

Depends.

If you only UPDATE that table, there will never be less freespace again,
unless you VACUUM FULL. In average every UPDATE frees as much space as
it reuses. If your data grows, via INSERTS, then yes, it should catch up
someday if you VACUUM often enough.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

pgsql-general by date:

Previous
From: Patrick Nelson
Date:
Subject: Series
Next
From: Andrew Sullivan
Date:
Subject: Re: Free space mapping (was Re: Multi-Versions and Vacuum)