Re: Query optimization - Mailing list pgsql-general

From Rob Sargent
Subject Re: Query optimization
Date
Msg-id 6072813E-9311-41CD-9987-89DD456098AC@gmail.com
Whole thread Raw
In response to Re: Query optimization  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general


On Mar 13, 2025, at 8:39 PM, Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:



On Fri, 14 Mar, 2025, 08:04 Rob Sargent, <robjsargent@gmail.com> wrote:

Hi

Gave you plan with out limit . Stats up to date insert .....on conflict do nothing runs some times 

Regards 
Durga Mahesh



But still using the “select exists”, thereby turning the result into a true/false value?  I do not follow your point on the usage of “on conflict”.  Is this also something whose behaviour has changed recently?  I assume it references the same table as the original sql?

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Re: Query optimization
Next
From: Ron Johnson
Date:
Subject: Re: Query optimization