Timeline for Optimizing fetching many rows with IN clause
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 26, 2022 at 15:59 | comment | added | Laurenz Albe |
The index-only scan will be even faster if you VACUUM the table.
|
|
| Oct 25, 2022 at 18:50 | answer | added | jjanes | timeline score: 0 | |
| Oct 25, 2022 at 17:41 | comment | added | user1822 | Postgres 14 introduced this change: "Allow hash lookup for IN clauses with many constants". So the IN operator might even be faster than in your tests. | |
| Oct 25, 2022 at 17:22 | history | asked | Cowabunga | CC BY-SA 4.0 |