Re: Query optimization

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Query optimization
Дата
Msg-id 6072813E-9311-41CD-9987-89DD456098AC@gmail.com
обсуждение исходный текст
Ответ на Re: Query optimization  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Список 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 по дате отправления: