| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | jb(at)jbitc(dot)de, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Index Only Scans with functions |
| Date: | 2026-07-06 15:49:36 |
| Message-ID: | CAKFQuwZkZb6BXA3ELVQnAZKWk_VL3jcv0ZaQszRq9zRnALJXOA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Mon, Jul 6, 2026 at 8:44 AM PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/18/indexes-index-only-scans.html
>
> and concludes that an index-only scan is not possible."
>
> I tried to reproduce the behavior, but it used the index (which is good):
>
You haven't demonstrated it using an index ONLY scan which is what that
section is talking about.
> QUERY PLAN
>
> -----------------------------------------------------------------------------------------------------------
> Index Scan using t_i1 on t (cost=0.42..8.69 rows=1 width=4) (actual
> time=0.034..0.035 rows=1.00 loops=1)
>
>
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | surya poondla | 2026-07-06 23:52:10 | Re: doc: Clarify ANALYZE VERBOSE output |
| Previous Message | TheOtherBrian1 | 2026-07-06 02:09:02 | [PATCH] doc: outline all planner nodes |