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: David Rowley <david.rowley@xxxxxxxxxxxxxxx>
Date: Wed, 28 Feb 2018 13:15:45 +1300
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>, Hadi Moshayedi <hadi@xxxxxxxxxxxxx>, Postgres General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <20180227221141.tubymz7ol4wjoqiz@alap3.anarazel.de>
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>

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.

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

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

Follow-Ups:
- Re: index-only-scan when there is an index on all columns
  - From: Andres Freund

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

Prev by Date: Re: Creating complex track changes database - challenge!
Next by Date: Re: Given a set of daterange, finding the continuous range that includes a particular date (aggregates)
Previous by thread: Re: index-only-scan when there is an index on all columns
Next by thread: Re: index-only-scan when there is an index on all columns
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]