Re: a lot of session wait on lock relation

Hi James, Could share the related test setup details? Would like to look into this. Thanks, Chetan On Thu, 15 May 2025 at 09:27, James Pang wrote: > Hi, >PGv 15.10, many session coming in doing "insert into tablexxx > values" in parallel, this is a range partiti

Re: Partition pruning is not happening (even in PG18)

'd need to move that to the Path >> generation phase so that we didn't accidentally reject Paths which >> could be cheaper than we first think. >> >> > Also, how could I contribute to get this partition pruning to work? >> >> The pgsql-hackers mailing list is where all the discussions about that >> happen. There is plenty of past discussions on these topics. One such >> (fairly) recent discussion is in [1]. There are plenty more, including >> some ideas from Robert Haas about how we might cost run-time partition >> pruning. That was likely around 2017-2018 range, so you might need to >> dig deep to find that. >> >> David >> >> [1] >> https://www.postgresql.org/message-id/flat/CAApHDvoC7n_oceb%3D8z%2BMY8sTgH4xa%2ByAwBxZ4Dxv8pwkT9bOcA%40mail.gmail.com#45314d3d01ef8ad1eebe72111989062c >> > > > -- > *Lauro Ojeda* > -- -- Regards, Chetan