Re: PostgreSQL does not choose my indexes well

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

Subject: Re: PostgreSQL does not choose my indexes well
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Thu, 23 Apr 2020 10:20:41 -0600
Cc: "David G. Johnston" <david.g.johnston@xxxxxxxxx>, Thomas Kellerer <shammat@xxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <4315.1587655779@sss.pgh.pa.us>
References: <35dc90d6-e0c2-13b8-3184-e3db5d854a78@gmail.com> <1bb37a19-77f6-8c49-073e-ed6251c98583@gmx.net> <CAKFQuwY9twbudMDvmuo+9Mjy0y-cJcvzPazD07-oB+WV1qOMnA@mail.gmail.com> <4315.1587655779@sss.pgh.pa.us>

"unless the table is mostly marked all-visible"

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

Follow-Ups:
- Re: PostgreSQL does not choose my indexes well
  - From: Tom Lane

References:
- PostgreSQL does not choose my indexes well
  - From: Arcadio Ortega Reinoso
- Re: PostgreSQL does not choose my indexes well
  - From: Thomas Kellerer
- Re: PostgreSQL does not choose my indexes well
  - From: David G. Johnston
- Re: PostgreSQL does not choose my indexes well
  - From: Tom Lane

Prev by Date: Re: PostgreSQL does not choose my indexes well
Next by Date: Re: PostgreSQL does not choose my indexes well
Previous by thread: Re: PostgreSQL does not choose my indexes well
Next by thread: Re: PostgreSQL does not choose my indexes well
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux