Re: Self-join optimisation

2021-03-12 Thread Hywel Carver
Hi, thanks for your replies. I've tested the patch and it works for me in the cases where I'd use it. > And explain why your application is doing queries like this, and why it can't be changed to changed to not generate such queries. Reading the thread, it looks like some of the requests for

Re: Self-join optimisation

2021-03-11 Thread Tomas Vondra
On 3/11/21 3:39 PM, Hywel Carver wrote: > Great! It looks like it's been in commitfest status for a few years. Is > there anything someone like me (outside the pgsql-hackers community) can > do to help it get reviewed this time around? > Well, you could do a review, or at least test it with the

Re: Self-join optimisation

2021-03-11 Thread Hywel Carver
Great! It looks like it's been in commitfest status for a few years. Is there anything someone like me (outside the pgsql-hackers community) can do to help it get reviewed this time around? On Thu, Mar 11, 2021 at 2:32 PM Matthias van de Meent < boekewurm+postg...@gmail.com> wrote: > On Thu, 11

Re: Self-join optimisation

2021-03-11 Thread Justin Pryzby
On Thu, Mar 11, 2021 at 03:32:16PM +0100, Matthias van de Meent wrote: > On Thu, 11 Mar 2021 at 15:15, Hywel Carver wrote: > > I asked this question in the Postgres Slack, and was recommended to ask > > here instead. > > > > A few times, I've been in a situation where I want to join a table to

Re: Self-join optimisation

2021-03-11 Thread Matthias van de Meent
On Thu, 11 Mar 2021 at 15:15, Hywel Carver wrote: > > Hi, > > I asked this question in the Postgres Slack, and was recommended to ask here > instead. > > A few times, I've been in a situation where I want to join a table to itself > on its primary key. That typically happens because I have some

Self-join optimisation

2021-03-11 Thread Hywel Carver
Hi, I asked this question in the Postgres Slack, and was recommended to ask here instead. A few times, I've been in a situation where I want to join a table to itself on its primary key. That typically happens because I have some kind of summary view, which I then want to join to the original