From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Postgres 11 release notes |
Date: | 2018-05-11 19:11:31 |
Message-ID: | 20180511191131.GG18510@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
On Fri, May 11, 2018 at 04:00:58PM -0300, Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
> > OK, so what is the text that people will understand? This?
> >
> > Prevent manual VACUUMs on append-only tables from performing
> > needless index scans
>
> Make vacuum cheaper by avoiding scans of btree indexes when not
> necessary
> ?
>
> Why "manual vacuum"? It's a problem with vacuums invoked from
> autovacuum too.
Uh, from the commit it says:
When workload on particular table is append-only, then autovacuum
isn't intended to touch this table. However, user may run vacuum
manually in order to fill visibility map and get benefits of
--------
index-only scans. Then ambulkdelete wouldn't be called for
indexes of such table (because no heap tuples were deleted), only
---------------------------
amvacuumcleanup would be called In this case, amvacuumcleanup
would perform full index scan for two objectives: put recyclable
pages into free space map and update index statistics.
Why would autovacuum run on a table with no expired index entries?
Personally, I think the fact that autovacuum doesn't run on suvch tables
and therefore doesn't automatically do index-only scans is a problem. I
tried to fix it years ago, but failed and gave up.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2018-05-11 19:14:24 | Re: Postgres 11 release notes |
Previous Message | Andres Freund | 2018-05-11 19:04:10 | Re: Postgres 11 release notes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2018-05-11 19:14:24 | Re: Postgres 11 release notes |
Previous Message | Andres Freund | 2018-05-11 19:04:10 | Re: Postgres 11 release notes |