Re: Visibility map, partial vacuums - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Visibility map, partial vacuums
Date
Msg-id 4929D923.7050001@zeut.net
Whole thread Raw
In response to Re: Visibility map, partial vacuums  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> However, my comment above was too optimistic, because in an insert-only
> scenario autovac would in fact not trigger VACUUM at all, only ANALYZE.
>
> So it seems like we do indeed want to rejigger autovac's rules a bit
> to account for the possibility of wanting to apply vacuum to get
> visibility bits set.

I'm sure I'm missing something, but I thought the point of this was to 
lessen the impact of VACUUM and now you are suggesting that we have to 
add vacuums to tables that have never needed one before.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Visibility map, partial vacuums
Next
From: "Jaime Casanova"
Date:
Subject: Re: [PATCHES] Solve a problem of LC_TIME of windows.