Re: index-only-scan when there is an index on all columns

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Hadi Moshayedi <hadi(at)citusdata(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: index-only-scan when there is an index on all columns
Date: 2018-02-28 00:15:45
Message-ID: CAKJS1f_yYOVGwchoX-VP7Hp0yOeCpk_BTyjq=Qyj+hvV5am6FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 28 February 2018 at 11:11, Andres Freund <andres(at)anarazel(dot)de> wrote:
> I'm fairly certain that only vacuum and table rewrites like cluster sets
> all-visible,

I don't think the pages are set all visible again after a rewrite.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-02-28 00:19:40 Re: index-only-scan when there is an index on all columns
Previous Message Ken Tanzer 2018-02-28 00:15:14 Re: Given a set of daterange, finding the continuous range that includes a particular date (aggregates)