Horton

Re: missing indexes in indexlist with partitioned tables

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Arne Roland <A.Roland@index.de>
Cc: Julien Rouhaud <rjuju123@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2022-01-17T18:16:08Z
Lists: pgsql-hackers 
Hmm, can you show cases of queries for which having this new
partIndexlist changes plans?

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)

Commits

  1. Allow left join removals and unique joins on partitioned tables

  2. Add index on pg_publication_rel.prpubid