Costs of Heap Fetches in Postgres 13

From: Jens(dot)Wilke(at)parcIT(dot)de
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Costs of Heap Fetches in Postgres 13
Date: 2020-07-30 17:20:52
Message-ID: 202007301720.06UHKriG028782@mail-srz-p-02.noc.fiducia.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

does the planner do estimates about heap fetches on index only scans and
takes them into account?
At least in Pg 13? If so, is it possible to lower those costs?
random_page_costs seems not to have any influence.
Looks like they cause bad planner decisions.
Tuning Vacuum is not an option ;)

regards, Jens

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kyotaro Horiguchi 2020-07-31 01:13:29 Re: Questions about Logical Replication - Issue ???
Previous Message Argha Deep Ghoshal 2020-07-30 15:59:26 Re: PSQLException: An I/O error occurred while sending to the backend.