Postgres Pro
Downloads
Home   >   mailing lists

Costs of Heap Fetches in Postgres 13 - Mailing list pgsql-general

From Jens.Wilke@parcIT.de
Subject Costs of Heap Fetches in Postgres 13
Date
Msg-id 202007301720.06UHKriG028782@mail-srz-p-02.noc.fiducia.de
Whole thread Raw
Responses Re: Costs of Heap Fetches in Postgres 13
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Argha Deep Ghoshal
Date:
Subject: Re: PSQLException: An I/O error occurred while sending to the backend.
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Questions about Logical Replication - Issue ???