Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: index-only-scan when there is an index on all columns
From: Andres Freund <andres@xxxxxxxxxxx>
Date: Tue, 27 Feb 2018 16:19:40 -0800
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>, Hadi Moshayedi <hadi@xxxxxxxxxxxxx>, Postgres General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAKJS1f_yYOVGwchoX-VP7Hp0yOeCpk_BTyjq=Qyj+hvV5am6FQ@mail.gmail.com>
References: <CA+_kT_f6fNS71Z6Dd-hca4-YeLTHgOgKOydE2W0zVwJdr534SA@mail.gmail.com> <25619.1519765684@sss.pgh.pa.us> <CAKFQuwan3avGvqhX=jB4EcMOUeD7P2yp_8-7YpToZnx=4KXb2Q@mail.gmail.com> <28385.1519768691@sss.pgh.pa.us> <20180227221141.tubymz7ol4wjoqiz@alap3.anarazel.de> <CAKJS1f_yYOVGwchoX-VP7Hp0yOeCpk_BTyjq=Qyj+hvV5am6FQ@mail.gmail.com>

On 2018-02-28 13:15:45 +1300, David Rowley wrote:
> On 28 February 2018 at 11:11, Andres Freund <andres@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- index-only-scan when there is an index on all columns
  - From: Hadi Moshayedi
- Re: index-only-scan when there is an index on all columns
  - From: Tom Lane
- Re: index-only-scan when there is an index on all columns
  - From: David G. Johnston
- Re: index-only-scan when there is an index on all columns
  - From: Tom Lane
- Re: index-only-scan when there is an index on all columns
  - From: Andres Freund
- Re: index-only-scan when there is an index on all columns
  - From: David Rowley

Prev by Date: Re: Given a set of daterange, finding the continuous range that includes a particular date (aggregates)
Next by Date: Re: Parallel Query - Can it be used within functions?
Previous by thread: Re: index-only-scan when there is an index on all columns
Next by thread: Enforce primary key on every table during dev?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]