Re: Unexpected planner choice in simple JOIN
| От | Mark Kirkwood |
|---|---|
| Тема | Re: Unexpected planner choice in simple JOIN |
| Дата | |
| Msg-id | d9620380-9e84-4256-8593-d3830495dc81@gmail.com обсуждение исходный текст |
| Ответ на | Re: Unexpected planner choice in simple JOIN (David Rowley <dgrowleyml@gmail.com>) |
| Ответы |
Re: Unexpected planner choice in simple JOIN
|
| Список | pgsql-performance |
I don't think so - while the case I posted used a hash index on the child table, exactly the sane behaviour happens if it is a btree (I probably should have mentioned that sorry). Background is I discovered this while playing about with hash indexes...which I must say - someone has done excellent work on as in this *particular cases* they are getting me better query performance! regards Mark On 08/01/2026 16:56, David Rowley wrote: > On Thu, 8 Jan 2026 at 16:34, Mark Kirkwood <mark.kirkwood@gmail.com> wrote: >> This does seem to be related to parallel planning: > Isn't it just a case of hash indexes not allowing parallel scans? > > David
В списке pgsql-performance по дате отправления: