| From: | Alexandre Felipe <alexandre(dot)felipe(at)tpro(dot)io> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Testing Index Skip scan |
| Date: | 2022-06-28 11:46:07 |
| Message-ID: | CAPYutMRJ-N_pjGyUqdNyhOyPX7Q3DG_Kbetes13RpB6zPDH-_g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I have been interested in a query that returns a batch of results filtered
by a subset of the first column of an index and ordered by the second.
I created a simple (hopefully) reproducible example of the issue, the two
queries describe the same data but have very different costs (explain
output included in the attached file).
server_version 12.8
On slack #pgsql-hackers channel, @sfrost, it was suggested that what I
described is achieved by index skip scan. How can I get a development build
to test this feature?
| Attachment | Content-Type | Size |
|---|---|---|
| psql-skip-index-scan.txt | text/plain | 5.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Steele | 2022-06-28 11:47:04 | Re: Comments referring to pg_start/stop_backup |
| Previous Message | Simon Riggs | 2022-06-28 11:45:16 | Re: making relfilenodes 56 bits |