random-page-cost

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: h(at)husseinnasser(dot)com
Subject: random-page-cost
Date: 2023-01-04 23:24:56
Message-ID: 167287469662.659.11940707264082116903@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/runtime-config-query.html
Description:

Two comments on random-page-cost parameter here
https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RANDOM-PAGE-COST

1) Adding a paragraph reminding us what random-access really mean in
postgres would be extremely valuable. I find the first paragraph from the
index - only scan section perfect. "This means that in an ordinary index
scan, each row retrieval requires fetching data from both the index and the
heap. Furthermore, while the index entries that match a given indexable
WHERE condition are usually close together in the index, the table rows they
reference might be anywhere in the heap. The heap-access portion of an index
scan thus involves a lot of random access into the heap, which can be slow,
particularly on traditional rotating media. "

2) A question, based on the definition of what random-access mean in
postgres (hits to the heap) does the random-page-cost affect index-only and
covering index scans at all? (assume zero heap fetches from hints etc.)? if
no can we also add a note there.

thank you!
Hussein

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2023-01-05 06:23:22 Tutorial make command comment
Previous Message Peter Eisentraut 2023-01-04 07:12:58 Re: Tablespace with multiple locations