Re: PostgreSQL does not choose my indexes well

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Thomas Kellerer <shammat(at)gmx(dot)net>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL does not choose my indexes well
Date: 2020-04-23 16:20:41
Message-ID: CAHOFxGrf_CsHgfQKnQp18G0_1CC6aQCbQ5Rz5JuD2u_rSAQWDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> "unless the table is mostly marked all-visible"

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2020-04-23 16:31:16 Re: PostgreSQL does not choose my indexes well
Previous Message Tom Lane 2020-04-23 15:29:39 Re: PostgreSQL does not choose my indexes well