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

From: Andres Freund <andres(at)anarazel(dot)de>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
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:19:40
Message-ID: 20180228001940.lgzcxxkyg34as6z2@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2018-02-28 13:15:45 +1300, David Rowley wrote:
> 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.

You're right. We freeze the tuples, but don't set the heap / FSM bits.

Greetings,

Andres Freund

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Krüger 2018-02-28 08:05:51 Re: Parallel Query - Can it be used within functions?
Previous Message David Rowley 2018-02-28 00:15:45 Re: index-only-scan when there is an index on all columns