| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Visibility map, partial vacuums |
| Date: | 2008-11-23 22:28:51 |
| Message-ID: | 4929D923.7050001@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2008-11-24 01:34:17 | Re: pgsql: Explicitly bind gettext() to the UTF8 locale when in use. |
| Previous Message | Tom Lane | 2008-11-23 21:18:42 | Re: Visibility map, partial vacuums |