Postgres Pro
Downloads
Home   >   mailing lists

Re: index-only-scan when there is an index on all columns - Mailing list pgsql-general

From David Rowley
Subject Re: index-only-scan when there is an index on all columns
Date
Msg-id CAKJS1f_yYOVGwchoX-VP7Hp0yOeCpk_BTyjq=Qyj+hvV5am6FQ@mail.gmail.com
Whole thread Raw
In response to Re: index-only-scan when there is an index on all columns  (Andres Freund <andres@anarazel.de>)
Responses Re: index-only-scan when there is an index on all columns  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Tree view 
On 28 February 2018 at 11:11, Andres Freund <andres@anarazel.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

pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Given a set of daterange, finding the continuous range thatincludes a particular date (aggregates)
Next
From: Andres Freund
Date:
Subject: Re: index-only-scan when there is an index on all columns