| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | grant <grant(at)amadensor(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Free space mapping (was Re: Multi-Versions and Vacuum) |
| Date: | 2002-07-19 20:07:28 |
| Message-ID: | 3D387180.CDB1A0A2@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-07-19 20:10:38 | Re: Free space mapping (was Re: Multi-Versions and Vacuum) |
| Previous Message | Patrick Nelson | 2002-07-19 20:04:50 | Series |