Re: PostgreSQL does not choose my indexes well - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL does not choose my indexes well
Date
Msg-id 14950.1587659476@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL does not choose my indexes well  (Michael Lewis <mlewis@entrata.com>)
List pgsql-performance
Michael Lewis <mlewis@entrata.com> writes:
>> "unless the table is mostly marked all-visible"

> Is that taken into account during planning when evaluating index scan vs
> sequential scan?

It is, although the planner's estimate is based on what the last ANALYZE
saw, which might be out-of-date.

            regards, tom lane



pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: PostgreSQL does not choose my indexes well
Next
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL does not choose my indexes well